package com.ygqh.baby.po;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class WdtQybOrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public WdtQybOrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andTradeIdIsNull() {
            addCriterion("trade_id is null");
            return (Criteria) this;
        }

        public Criteria andTradeIdIsNotNull() {
            addCriterion("trade_id is not null");
            return (Criteria) this;
        }

        public Criteria andTradeIdEqualTo(Long value) {
            addCriterion("trade_id =", value, "tradeId");
            return (Criteria) this;
        }

        public Criteria andTradeIdNotEqualTo(Long value) {
            addCriterion("trade_id <>", value, "tradeId");
            return (Criteria) this;
        }

        public Criteria andTradeIdGreaterThan(Long value) {
            addCriterion("trade_id >", value, "tradeId");
            return (Criteria) this;
        }

        public Criteria andTradeIdGreaterThanOrEqualTo(Long value) {
            addCriterion("trade_id >=", value, "tradeId");
            return (Criteria) this;
        }

        public Criteria andTradeIdLessThan(Long value) {
            addCriterion("trade_id <", value, "tradeId");
            return (Criteria) this;
        }

        public Criteria andTradeIdLessThanOrEqualTo(Long value) {
            addCriterion("trade_id <=", value, "tradeId");
            return (Criteria) this;
        }

        public Criteria andTradeIdIn(List<Long> values) {
            addCriterion("trade_id in", values, "tradeId");
            return (Criteria) this;
        }

        public Criteria andTradeIdNotIn(List<Long> values) {
            addCriterion("trade_id not in", values, "tradeId");
            return (Criteria) this;
        }

        public Criteria andTradeIdBetween(Long value1, Long value2) {
            addCriterion("trade_id between", value1, value2, "tradeId");
            return (Criteria) this;
        }

        public Criteria andTradeIdNotBetween(Long value1, Long value2) {
            addCriterion("trade_id not between", value1, value2, "tradeId");
            return (Criteria) this;
        }

        public Criteria andBadReasonIsNull() {
            addCriterion("bad_reason is null");
            return (Criteria) this;
        }

        public Criteria andBadReasonIsNotNull() {
            addCriterion("bad_reason is not null");
            return (Criteria) this;
        }

        public Criteria andBadReasonEqualTo(String value) {
            addCriterion("bad_reason =", value, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonNotEqualTo(String value) {
            addCriterion("bad_reason <>", value, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonGreaterThan(String value) {
            addCriterion("bad_reason >", value, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonGreaterThanOrEqualTo(String value) {
            addCriterion("bad_reason >=", value, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonLessThan(String value) {
            addCriterion("bad_reason <", value, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonLessThanOrEqualTo(String value) {
            addCriterion("bad_reason <=", value, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonLike(String value) {
            addCriterion("bad_reason like", value, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonNotLike(String value) {
            addCriterion("bad_reason not like", value, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonIn(List<String> values) {
            addCriterion("bad_reason in", values, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonNotIn(List<String> values) {
            addCriterion("bad_reason not in", values, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonBetween(String value1, String value2) {
            addCriterion("bad_reason between", value1, value2, "badReason");
            return (Criteria) this;
        }

        public Criteria andBadReasonNotBetween(String value1, String value2) {
            addCriterion("bad_reason not between", value1, value2, "badReason");
            return (Criteria) this;
        }

        public Criteria andTradeNoIsNull() {
            addCriterion("trade_no is null");
            return (Criteria) this;
        }

        public Criteria andTradeNoIsNotNull() {
            addCriterion("trade_no is not null");
            return (Criteria) this;
        }

        public Criteria andTradeNoEqualTo(String value) {
            addCriterion("trade_no =", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotEqualTo(String value) {
            addCriterion("trade_no <>", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoGreaterThan(String value) {
            addCriterion("trade_no >", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoGreaterThanOrEqualTo(String value) {
            addCriterion("trade_no >=", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoLessThan(String value) {
            addCriterion("trade_no <", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoLessThanOrEqualTo(String value) {
            addCriterion("trade_no <=", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoLike(String value) {
            addCriterion("trade_no like", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotLike(String value) {
            addCriterion("trade_no not like", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoIn(List<String> values) {
            addCriterion("trade_no in", values, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotIn(List<String> values) {
            addCriterion("trade_no not in", values, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoBetween(String value1, String value2) {
            addCriterion("trade_no between", value1, value2, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotBetween(String value1, String value2) {
            addCriterion("trade_no not between", value1, value2, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andPlatformIdIsNull() {
            addCriterion("platform_id is null");
            return (Criteria) this;
        }

        public Criteria andPlatformIdIsNotNull() {
            addCriterion("platform_id is not null");
            return (Criteria) this;
        }

        public Criteria andPlatformIdEqualTo(Integer value) {
            addCriterion("platform_id =", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdNotEqualTo(Integer value) {
            addCriterion("platform_id <>", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdGreaterThan(Integer value) {
            addCriterion("platform_id >", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("platform_id >=", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdLessThan(Integer value) {
            addCriterion("platform_id <", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdLessThanOrEqualTo(Integer value) {
            addCriterion("platform_id <=", value, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdIn(List<Integer> values) {
            addCriterion("platform_id in", values, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdNotIn(List<Integer> values) {
            addCriterion("platform_id not in", values, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdBetween(Integer value1, Integer value2) {
            addCriterion("platform_id between", value1, value2, "platformId");
            return (Criteria) this;
        }

        public Criteria andPlatformIdNotBetween(Integer value1, Integer value2) {
            addCriterion("platform_id not between", value1, value2, "platformId");
            return (Criteria) this;
        }

        public Criteria andShopNoIsNull() {
            addCriterion("shop_no is null");
            return (Criteria) this;
        }

        public Criteria andShopNoIsNotNull() {
            addCriterion("shop_no is not null");
            return (Criteria) this;
        }

        public Criteria andShopNoEqualTo(String value) {
            addCriterion("shop_no =", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoNotEqualTo(String value) {
            addCriterion("shop_no <>", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoGreaterThan(String value) {
            addCriterion("shop_no >", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoGreaterThanOrEqualTo(String value) {
            addCriterion("shop_no >=", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoLessThan(String value) {
            addCriterion("shop_no <", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoLessThanOrEqualTo(String value) {
            addCriterion("shop_no <=", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoLike(String value) {
            addCriterion("shop_no like", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoNotLike(String value) {
            addCriterion("shop_no not like", value, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoIn(List<String> values) {
            addCriterion("shop_no in", values, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoNotIn(List<String> values) {
            addCriterion("shop_no not in", values, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoBetween(String value1, String value2) {
            addCriterion("shop_no between", value1, value2, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNoNotBetween(String value1, String value2) {
            addCriterion("shop_no not between", value1, value2, "shopNo");
            return (Criteria) this;
        }

        public Criteria andShopNameIsNull() {
            addCriterion("shop_name is null");
            return (Criteria) this;
        }

        public Criteria andShopNameIsNotNull() {
            addCriterion("shop_name is not null");
            return (Criteria) this;
        }

        public Criteria andShopNameEqualTo(String value) {
            addCriterion("shop_name =", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotEqualTo(String value) {
            addCriterion("shop_name <>", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameGreaterThan(String value) {
            addCriterion("shop_name >", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameGreaterThanOrEqualTo(String value) {
            addCriterion("shop_name >=", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLessThan(String value) {
            addCriterion("shop_name <", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLessThanOrEqualTo(String value) {
            addCriterion("shop_name <=", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLike(String value) {
            addCriterion("shop_name like", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotLike(String value) {
            addCriterion("shop_name not like", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameIn(List<String> values) {
            addCriterion("shop_name in", values, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotIn(List<String> values) {
            addCriterion("shop_name not in", values, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameBetween(String value1, String value2) {
            addCriterion("shop_name between", value1, value2, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotBetween(String value1, String value2) {
            addCriterion("shop_name not between", value1, value2, "shopName");
            return (Criteria) this;
        }

        public Criteria andWarehouseTypeIsNull() {
            addCriterion("warehouse_type is null");
            return (Criteria) this;
        }

        public Criteria andWarehouseTypeIsNotNull() {
            addCriterion("warehouse_type is not null");
            return (Criteria) this;
        }

        public Criteria andWarehouseTypeEqualTo(Integer value) {
            addCriterion("warehouse_type =", value, "warehouseType");
            return (Criteria) this;
        }

        public Criteria andWarehouseTypeNotEqualTo(Integer value) {
            addCriterion("warehouse_type <>", value, "warehouseType");
            return (Criteria) this;
        }

        public Criteria andWarehouseTypeGreaterThan(Integer value) {
            addCriterion("warehouse_type >", value, "warehouseType");
            return (Criteria) this;
        }

        public Criteria andWarehouseTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("warehouse_type >=", value, "warehouseType");
            return (Criteria) this;
        }

        public Criteria andWarehouseTypeLessThan(Integer value) {
            addCriterion("warehouse_type <", value, "warehouseType");
            return (Criteria) this;
        }

        public Criteria andWarehouseTypeLessThanOrEqualTo(Integer value) {
            addCriterion("warehouse_type <=", value, "warehouseType");
            return (Criteria) this;
        }

        public Criteria andWarehouseTypeIn(List<Integer> values) {
            addCriterion("warehouse_type in", values, "warehouseType");
            return (Criteria) this;
        }

        public Criteria andWarehouseTypeNotIn(List<Integer> values) {
            addCriterion("warehouse_type not in", values, "warehouseType");
            return (Criteria) this;
        }

        public Criteria andWarehouseTypeBetween(Integer value1, Integer value2) {
            addCriterion("warehouse_type between", value1, value2, "warehouseType");
            return (Criteria) this;
        }

        public Criteria andWarehouseTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("warehouse_type not between", value1, value2, "warehouseType");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoIsNull() {
            addCriterion("warehouse_no is null");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoIsNotNull() {
            addCriterion("warehouse_no is not null");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoEqualTo(String value) {
            addCriterion("warehouse_no =", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoNotEqualTo(String value) {
            addCriterion("warehouse_no <>", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoGreaterThan(String value) {
            addCriterion("warehouse_no >", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoGreaterThanOrEqualTo(String value) {
            addCriterion("warehouse_no >=", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoLessThan(String value) {
            addCriterion("warehouse_no <", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoLessThanOrEqualTo(String value) {
            addCriterion("warehouse_no <=", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoLike(String value) {
            addCriterion("warehouse_no like", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoNotLike(String value) {
            addCriterion("warehouse_no not like", value, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoIn(List<String> values) {
            addCriterion("warehouse_no in", values, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoNotIn(List<String> values) {
            addCriterion("warehouse_no not in", values, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoBetween(String value1, String value2) {
            addCriterion("warehouse_no between", value1, value2, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andWarehouseNoNotBetween(String value1, String value2) {
            addCriterion("warehouse_no not between", value1, value2, "warehouseNo");
            return (Criteria) this;
        }

        public Criteria andSrcTidsIsNull() {
            addCriterion("src_tids is null");
            return (Criteria) this;
        }

        public Criteria andSrcTidsIsNotNull() {
            addCriterion("src_tids is not null");
            return (Criteria) this;
        }

        public Criteria andSrcTidsEqualTo(String value) {
            addCriterion("src_tids =", value, "srcTids");
            return (Criteria) this;
        }

        public Criteria andSrcTidsNotEqualTo(String value) {
            addCriterion("src_tids <>", value, "srcTids");
            return (Criteria) this;
        }

        public Criteria andSrcTidsGreaterThan(String value) {
            addCriterion("src_tids >", value, "srcTids");
            return (Criteria) this;
        }

        public Criteria andSrcTidsGreaterThanOrEqualTo(String value) {
            addCriterion("src_tids >=", value, "srcTids");
            return (Criteria) this;
        }

        public Criteria andSrcTidsLessThan(String value) {
            addCriterion("src_tids <", value, "srcTids");
            return (Criteria) this;
        }

        public Criteria andSrcTidsLessThanOrEqualTo(String value) {
            addCriterion("src_tids <=", value, "srcTids");
            return (Criteria) this;
        }

        public Criteria andSrcTidsLike(String value) {
            addCriterion("src_tids like", value, "srcTids");
            return (Criteria) this;
        }

        public Criteria andSrcTidsNotLike(String value) {
            addCriterion("src_tids not like", value, "srcTids");
            return (Criteria) this;
        }

        public Criteria andSrcTidsIn(List<String> values) {
            addCriterion("src_tids in", values, "srcTids");
            return (Criteria) this;
        }

        public Criteria andSrcTidsNotIn(List<String> values) {
            addCriterion("src_tids not in", values, "srcTids");
            return (Criteria) this;
        }

        public Criteria andSrcTidsBetween(String value1, String value2) {
            addCriterion("src_tids between", value1, value2, "srcTids");
            return (Criteria) this;
        }

        public Criteria andSrcTidsNotBetween(String value1, String value2) {
            addCriterion("src_tids not between", value1, value2, "srcTids");
            return (Criteria) this;
        }

        public Criteria andTradeStatusIsNull() {
            addCriterion("trade_status is null");
            return (Criteria) this;
        }

        public Criteria andTradeStatusIsNotNull() {
            addCriterion("trade_status is not null");
            return (Criteria) this;
        }

        public Criteria andTradeStatusEqualTo(Integer value) {
            addCriterion("trade_status =", value, "tradeStatus");
            return (Criteria) this;
        }

        public Criteria andTradeStatusNotEqualTo(Integer value) {
            addCriterion("trade_status <>", value, "tradeStatus");
            return (Criteria) this;
        }

        public Criteria andTradeStatusGreaterThan(Integer value) {
            addCriterion("trade_status >", value, "tradeStatus");
            return (Criteria) this;
        }

        public Criteria andTradeStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("trade_status >=", value, "tradeStatus");
            return (Criteria) this;
        }

        public Criteria andTradeStatusLessThan(Integer value) {
            addCriterion("trade_status <", value, "tradeStatus");
            return (Criteria) this;
        }

        public Criteria andTradeStatusLessThanOrEqualTo(Integer value) {
            addCriterion("trade_status <=", value, "tradeStatus");
            return (Criteria) this;
        }

        public Criteria andTradeStatusIn(List<Integer> values) {
            addCriterion("trade_status in", values, "tradeStatus");
            return (Criteria) this;
        }

        public Criteria andTradeStatusNotIn(List<Integer> values) {
            addCriterion("trade_status not in", values, "tradeStatus");
            return (Criteria) this;
        }

        public Criteria andTradeStatusBetween(Integer value1, Integer value2) {
            addCriterion("trade_status between", value1, value2, "tradeStatus");
            return (Criteria) this;
        }

        public Criteria andTradeStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("trade_status not between", value1, value2, "tradeStatus");
            return (Criteria) this;
        }

        public Criteria andConsignStatusIsNull() {
            addCriterion("consign_status is null");
            return (Criteria) this;
        }

        public Criteria andConsignStatusIsNotNull() {
            addCriterion("consign_status is not null");
            return (Criteria) this;
        }

        public Criteria andConsignStatusEqualTo(Integer value) {
            addCriterion("consign_status =", value, "consignStatus");
            return (Criteria) this;
        }

        public Criteria andConsignStatusNotEqualTo(Integer value) {
            addCriterion("consign_status <>", value, "consignStatus");
            return (Criteria) this;
        }

        public Criteria andConsignStatusGreaterThan(Integer value) {
            addCriterion("consign_status >", value, "consignStatus");
            return (Criteria) this;
        }

        public Criteria andConsignStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("consign_status >=", value, "consignStatus");
            return (Criteria) this;
        }

        public Criteria andConsignStatusLessThan(Integer value) {
            addCriterion("consign_status <", value, "consignStatus");
            return (Criteria) this;
        }

        public Criteria andConsignStatusLessThanOrEqualTo(Integer value) {
            addCriterion("consign_status <=", value, "consignStatus");
            return (Criteria) this;
        }

        public Criteria andConsignStatusIn(List<Integer> values) {
            addCriterion("consign_status in", values, "consignStatus");
            return (Criteria) this;
        }

        public Criteria andConsignStatusNotIn(List<Integer> values) {
            addCriterion("consign_status not in", values, "consignStatus");
            return (Criteria) this;
        }

        public Criteria andConsignStatusBetween(Integer value1, Integer value2) {
            addCriterion("consign_status between", value1, value2, "consignStatus");
            return (Criteria) this;
        }

        public Criteria andConsignStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("consign_status not between", value1, value2, "consignStatus");
            return (Criteria) this;
        }

        public Criteria andTradeTypeIsNull() {
            addCriterion("trade_type is null");
            return (Criteria) this;
        }

        public Criteria andTradeTypeIsNotNull() {
            addCriterion("trade_type is not null");
            return (Criteria) this;
        }

        public Criteria andTradeTypeEqualTo(Integer value) {
            addCriterion("trade_type =", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeNotEqualTo(Integer value) {
            addCriterion("trade_type <>", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeGreaterThan(Integer value) {
            addCriterion("trade_type >", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("trade_type >=", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeLessThan(Integer value) {
            addCriterion("trade_type <", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeLessThanOrEqualTo(Integer value) {
            addCriterion("trade_type <=", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeIn(List<Integer> values) {
            addCriterion("trade_type in", values, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeNotIn(List<Integer> values) {
            addCriterion("trade_type not in", values, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeBetween(Integer value1, Integer value2) {
            addCriterion("trade_type between", value1, value2, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("trade_type not between", value1, value2, "tradeType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermIsNull() {
            addCriterion("delivery_term is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermIsNotNull() {
            addCriterion("delivery_term is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermEqualTo(Integer value) {
            addCriterion("delivery_term =", value, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermNotEqualTo(Integer value) {
            addCriterion("delivery_term <>", value, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermGreaterThan(Integer value) {
            addCriterion("delivery_term >", value, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermGreaterThanOrEqualTo(Integer value) {
            addCriterion("delivery_term >=", value, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermLessThan(Integer value) {
            addCriterion("delivery_term <", value, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermLessThanOrEqualTo(Integer value) {
            addCriterion("delivery_term <=", value, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermIn(List<Integer> values) {
            addCriterion("delivery_term in", values, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermNotIn(List<Integer> values) {
            addCriterion("delivery_term not in", values, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermBetween(Integer value1, Integer value2) {
            addCriterion("delivery_term between", value1, value2, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andDeliveryTermNotBetween(Integer value1, Integer value2) {
            addCriterion("delivery_term not between", value1, value2, "deliveryTerm");
            return (Criteria) this;
        }

        public Criteria andFreezeReasonIsNull() {
            addCriterion("freeze_reason is null");
            return (Criteria) this;
        }

        public Criteria andFreezeReasonIsNotNull() {
            addCriterion("freeze_reason is not null");
            return (Criteria) this;
        }

        public Criteria andFreezeReasonEqualTo(Integer value) {
            addCriterion("freeze_reason =", value, "freezeReason");
            return (Criteria) this;
        }

        public Criteria andFreezeReasonNotEqualTo(Integer value) {
            addCriterion("freeze_reason <>", value, "freezeReason");
            return (Criteria) this;
        }

        public Criteria andFreezeReasonGreaterThan(Integer value) {
            addCriterion("freeze_reason >", value, "freezeReason");
            return (Criteria) this;
        }

        public Criteria andFreezeReasonGreaterThanOrEqualTo(Integer value) {
            addCriterion("freeze_reason >=", value, "freezeReason");
            return (Criteria) this;
        }

        public Criteria andFreezeReasonLessThan(Integer value) {
            addCriterion("freeze_reason <", value, "freezeReason");
            return (Criteria) this;
        }

        public Criteria andFreezeReasonLessThanOrEqualTo(Integer value) {
            addCriterion("freeze_reason <=", value, "freezeReason");
            return (Criteria) this;
        }

        public Criteria andFreezeReasonIn(List<Integer> values) {
            addCriterion("freeze_reason in", values, "freezeReason");
            return (Criteria) this;
        }

        public Criteria andFreezeReasonNotIn(List<Integer> values) {
            addCriterion("freeze_reason not in", values, "freezeReason");
            return (Criteria) this;
        }

        public Criteria andFreezeReasonBetween(Integer value1, Integer value2) {
            addCriterion("freeze_reason between", value1, value2, "freezeReason");
            return (Criteria) this;
        }

        public Criteria andFreezeReasonNotBetween(Integer value1, Integer value2) {
            addCriterion("freeze_reason not between", value1, value2, "freezeReason");
            return (Criteria) this;
        }

        public Criteria andRefundStatusIsNull() {
            addCriterion("refund_status is null");
            return (Criteria) this;
        }

        public Criteria andRefundStatusIsNotNull() {
            addCriterion("refund_status is not null");
            return (Criteria) this;
        }

        public Criteria andRefundStatusEqualTo(Integer value) {
            addCriterion("refund_status =", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotEqualTo(Integer value) {
            addCriterion("refund_status <>", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusGreaterThan(Integer value) {
            addCriterion("refund_status >", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("refund_status >=", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusLessThan(Integer value) {
            addCriterion("refund_status <", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusLessThanOrEqualTo(Integer value) {
            addCriterion("refund_status <=", value, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusIn(List<Integer> values) {
            addCriterion("refund_status in", values, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotIn(List<Integer> values) {
            addCriterion("refund_status not in", values, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusBetween(Integer value1, Integer value2) {
            addCriterion("refund_status between", value1, value2, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andRefundStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("refund_status not between", value1, value2, "refundStatus");
            return (Criteria) this;
        }

        public Criteria andFenxiaoTypeIsNull() {
            addCriterion("fenxiao_type is null");
            return (Criteria) this;
        }

        public Criteria andFenxiaoTypeIsNotNull() {
            addCriterion("fenxiao_type is not null");
            return (Criteria) this;
        }

        public Criteria andFenxiaoTypeEqualTo(Integer value) {
            addCriterion("fenxiao_type =", value, "fenxiaoType");
            return (Criteria) this;
        }

        public Criteria andFenxiaoTypeNotEqualTo(Integer value) {
            addCriterion("fenxiao_type <>", value, "fenxiaoType");
            return (Criteria) this;
        }

        public Criteria andFenxiaoTypeGreaterThan(Integer value) {
            addCriterion("fenxiao_type >", value, "fenxiaoType");
            return (Criteria) this;
        }

        public Criteria andFenxiaoTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("fenxiao_type >=", value, "fenxiaoType");
            return (Criteria) this;
        }

        public Criteria andFenxiaoTypeLessThan(Integer value) {
            addCriterion("fenxiao_type <", value, "fenxiaoType");
            return (Criteria) this;
        }

        public Criteria andFenxiaoTypeLessThanOrEqualTo(Integer value) {
            addCriterion("fenxiao_type <=", value, "fenxiaoType");
            return (Criteria) this;
        }

        public Criteria andFenxiaoTypeIn(List<Integer> values) {
            addCriterion("fenxiao_type in", values, "fenxiaoType");
            return (Criteria) this;
        }

        public Criteria andFenxiaoTypeNotIn(List<Integer> values) {
            addCriterion("fenxiao_type not in", values, "fenxiaoType");
            return (Criteria) this;
        }

        public Criteria andFenxiaoTypeBetween(Integer value1, Integer value2) {
            addCriterion("fenxiao_type between", value1, value2, "fenxiaoType");
            return (Criteria) this;
        }

        public Criteria andFenxiaoTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("fenxiao_type not between", value1, value2, "fenxiaoType");
            return (Criteria) this;
        }

        public Criteria andFenxiaoNickIsNull() {
            addCriterion("fenxiao_nick is null");
            return (Criteria) this;
        }

        public Criteria andFenxiaoNickIsNotNull() {
            addCriterion("fenxiao_nick is not null");
            return (Criteria) this;
        }

        public Criteria andFenxiaoNickEqualTo(String value) {
            addCriterion("fenxiao_nick =", value, "fenxiaoNick");
            return (Criteria) this;
        }

        public Criteria andFenxiaoNickNotEqualTo(String value) {
            addCriterion("fenxiao_nick <>", value, "fenxiaoNick");
            return (Criteria) this;
        }

        public Criteria andFenxiaoNickGreaterThan(String value) {
            addCriterion("fenxiao_nick >", value, "fenxiaoNick");
            return (Criteria) this;
        }

        public Criteria andFenxiaoNickGreaterThanOrEqualTo(String value) {
            addCriterion("fenxiao_nick >=", value, "fenxiaoNick");
            return (Criteria) this;
        }

        public Criteria andFenxiaoNickLessThan(String value) {
            addCriterion("fenxiao_nick <", value, "fenxiaoNick");
            return (Criteria) this;
        }

        public Criteria andFenxiaoNickLessThanOrEqualTo(String value) {
            addCriterion("fenxiao_nick <=", value, "fenxiaoNick");
            return (Criteria) this;
        }

        public Criteria andFenxiaoNickLike(String value) {
            addCriterion("fenxiao_nick like", value, "fenxiaoNick");
            return (Criteria) this;
        }

        public Criteria andFenxiaoNickNotLike(String value) {
            addCriterion("fenxiao_nick not like", value, "fenxiaoNick");
            return (Criteria) this;
        }

        public Criteria andFenxiaoNickIn(List<String> values) {
            addCriterion("fenxiao_nick in", values, "fenxiaoNick");
            return (Criteria) this;
        }

        public Criteria andFenxiaoNickNotIn(List<String> values) {
            addCriterion("fenxiao_nick not in", values, "fenxiaoNick");
            return (Criteria) this;
        }

        public Criteria andFenxiaoNickBetween(String value1, String value2) {
            addCriterion("fenxiao_nick between", value1, value2, "fenxiaoNick");
            return (Criteria) this;
        }

        public Criteria andFenxiaoNickNotBetween(String value1, String value2) {
            addCriterion("fenxiao_nick not between", value1, value2, "fenxiaoNick");
            return (Criteria) this;
        }

        public Criteria andTradeTimeIsNull() {
            addCriterion("trade_time is null");
            return (Criteria) this;
        }

        public Criteria andTradeTimeIsNotNull() {
            addCriterion("trade_time is not null");
            return (Criteria) this;
        }

        public Criteria andTradeTimeEqualTo(Date value) {
            addCriterion("trade_time =", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeNotEqualTo(Date value) {
            addCriterion("trade_time <>", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeGreaterThan(Date value) {
            addCriterion("trade_time >", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("trade_time >=", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeLessThan(Date value) {
            addCriterion("trade_time <", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeLessThanOrEqualTo(Date value) {
            addCriterion("trade_time <=", value, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeIn(List<Date> values) {
            addCriterion("trade_time in", values, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeNotIn(List<Date> values) {
            addCriterion("trade_time not in", values, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeBetween(Date value1, Date value2) {
            addCriterion("trade_time between", value1, value2, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andTradeTimeNotBetween(Date value1, Date value2) {
            addCriterion("trade_time not between", value1, value2, "tradeTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeIsNull() {
            addCriterion("pay_time is null");
            return (Criteria) this;
        }

        public Criteria andPayTimeIsNotNull() {
            addCriterion("pay_time is not null");
            return (Criteria) this;
        }

        public Criteria andPayTimeEqualTo(Date value) {
            addCriterion("pay_time =", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotEqualTo(Date value) {
            addCriterion("pay_time <>", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeGreaterThan(Date value) {
            addCriterion("pay_time >", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("pay_time >=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeLessThan(Date value) {
            addCriterion("pay_time <", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeLessThanOrEqualTo(Date value) {
            addCriterion("pay_time <=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeIn(List<Date> values) {
            addCriterion("pay_time in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotIn(List<Date> values) {
            addCriterion("pay_time not in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeBetween(Date value1, Date value2) {
            addCriterion("pay_time between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotBetween(Date value1, Date value2) {
            addCriterion("pay_time not between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria andCustomerNoIsNull() {
            addCriterion("customer_no is null");
            return (Criteria) this;
        }

        public Criteria andCustomerNoIsNotNull() {
            addCriterion("customer_no is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerNoEqualTo(String value) {
            addCriterion("customer_no =", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoNotEqualTo(String value) {
            addCriterion("customer_no <>", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoGreaterThan(String value) {
            addCriterion("customer_no >", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoGreaterThanOrEqualTo(String value) {
            addCriterion("customer_no >=", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoLessThan(String value) {
            addCriterion("customer_no <", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoLessThanOrEqualTo(String value) {
            addCriterion("customer_no <=", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoLike(String value) {
            addCriterion("customer_no like", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoNotLike(String value) {
            addCriterion("customer_no not like", value, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoIn(List<String> values) {
            addCriterion("customer_no in", values, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoNotIn(List<String> values) {
            addCriterion("customer_no not in", values, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoBetween(String value1, String value2) {
            addCriterion("customer_no between", value1, value2, "customerNo");
            return (Criteria) this;
        }

        public Criteria andCustomerNoNotBetween(String value1, String value2) {
            addCriterion("customer_no not between", value1, value2, "customerNo");
            return (Criteria) this;
        }

        public Criteria andPayAccountIsNull() {
            addCriterion("pay_account is null");
            return (Criteria) this;
        }

        public Criteria andPayAccountIsNotNull() {
            addCriterion("pay_account is not null");
            return (Criteria) this;
        }

        public Criteria andPayAccountEqualTo(String value) {
            addCriterion("pay_account =", value, "payAccount");
            return (Criteria) this;
        }

        public Criteria andPayAccountNotEqualTo(String value) {
            addCriterion("pay_account <>", value, "payAccount");
            return (Criteria) this;
        }

        public Criteria andPayAccountGreaterThan(String value) {
            addCriterion("pay_account >", value, "payAccount");
            return (Criteria) this;
        }

        public Criteria andPayAccountGreaterThanOrEqualTo(String value) {
            addCriterion("pay_account >=", value, "payAccount");
            return (Criteria) this;
        }

        public Criteria andPayAccountLessThan(String value) {
            addCriterion("pay_account <", value, "payAccount");
            return (Criteria) this;
        }

        public Criteria andPayAccountLessThanOrEqualTo(String value) {
            addCriterion("pay_account <=", value, "payAccount");
            return (Criteria) this;
        }

        public Criteria andPayAccountLike(String value) {
            addCriterion("pay_account like", value, "payAccount");
            return (Criteria) this;
        }

        public Criteria andPayAccountNotLike(String value) {
            addCriterion("pay_account not like", value, "payAccount");
            return (Criteria) this;
        }

        public Criteria andPayAccountIn(List<String> values) {
            addCriterion("pay_account in", values, "payAccount");
            return (Criteria) this;
        }

        public Criteria andPayAccountNotIn(List<String> values) {
            addCriterion("pay_account not in", values, "payAccount");
            return (Criteria) this;
        }

        public Criteria andPayAccountBetween(String value1, String value2) {
            addCriterion("pay_account between", value1, value2, "payAccount");
            return (Criteria) this;
        }

        public Criteria andPayAccountNotBetween(String value1, String value2) {
            addCriterion("pay_account not between", value1, value2, "payAccount");
            return (Criteria) this;
        }

        public Criteria andBuyerNickIsNull() {
            addCriterion("buyer_nick is null");
            return (Criteria) this;
        }

        public Criteria andBuyerNickIsNotNull() {
            addCriterion("buyer_nick is not null");
            return (Criteria) this;
        }

        public Criteria andBuyerNickEqualTo(String value) {
            addCriterion("buyer_nick =", value, "buyerNick");
            return (Criteria) this;
        }

        public Criteria andBuyerNickNotEqualTo(String value) {
            addCriterion("buyer_nick <>", value, "buyerNick");
            return (Criteria) this;
        }

        public Criteria andBuyerNickGreaterThan(String value) {
            addCriterion("buyer_nick >", value, "buyerNick");
            return (Criteria) this;
        }

        public Criteria andBuyerNickGreaterThanOrEqualTo(String value) {
            addCriterion("buyer_nick >=", value, "buyerNick");
            return (Criteria) this;
        }

        public Criteria andBuyerNickLessThan(String value) {
            addCriterion("buyer_nick <", value, "buyerNick");
            return (Criteria) this;
        }

        public Criteria andBuyerNickLessThanOrEqualTo(String value) {
            addCriterion("buyer_nick <=", value, "buyerNick");
            return (Criteria) this;
        }

        public Criteria andBuyerNickLike(String value) {
            addCriterion("buyer_nick like", value, "buyerNick");
            return (Criteria) this;
        }

        public Criteria andBuyerNickNotLike(String value) {
            addCriterion("buyer_nick not like", value, "buyerNick");
            return (Criteria) this;
        }

        public Criteria andBuyerNickIn(List<String> values) {
            addCriterion("buyer_nick in", values, "buyerNick");
            return (Criteria) this;
        }

        public Criteria andBuyerNickNotIn(List<String> values) {
            addCriterion("buyer_nick not in", values, "buyerNick");
            return (Criteria) this;
        }

        public Criteria andBuyerNickBetween(String value1, String value2) {
            addCriterion("buyer_nick between", value1, value2, "buyerNick");
            return (Criteria) this;
        }

        public Criteria andBuyerNickNotBetween(String value1, String value2) {
            addCriterion("buyer_nick not between", value1, value2, "buyerNick");
            return (Criteria) this;
        }

        public Criteria andReceiverNameIsNull() {
            addCriterion("receiver_name is null");
            return (Criteria) this;
        }

        public Criteria andReceiverNameIsNotNull() {
            addCriterion("receiver_name is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverNameEqualTo(String value) {
            addCriterion("receiver_name =", value, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameNotEqualTo(String value) {
            addCriterion("receiver_name <>", value, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameGreaterThan(String value) {
            addCriterion("receiver_name >", value, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_name >=", value, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameLessThan(String value) {
            addCriterion("receiver_name <", value, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameLessThanOrEqualTo(String value) {
            addCriterion("receiver_name <=", value, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameLike(String value) {
            addCriterion("receiver_name like", value, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameNotLike(String value) {
            addCriterion("receiver_name not like", value, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameIn(List<String> values) {
            addCriterion("receiver_name in", values, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameNotIn(List<String> values) {
            addCriterion("receiver_name not in", values, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameBetween(String value1, String value2) {
            addCriterion("receiver_name between", value1, value2, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverNameNotBetween(String value1, String value2) {
            addCriterion("receiver_name not between", value1, value2, "receiverName");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceIsNull() {
            addCriterion("receiver_province is null");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceIsNotNull() {
            addCriterion("receiver_province is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceEqualTo(String value) {
            addCriterion("receiver_province =", value, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceNotEqualTo(String value) {
            addCriterion("receiver_province <>", value, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceGreaterThan(String value) {
            addCriterion("receiver_province >", value, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_province >=", value, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceLessThan(String value) {
            addCriterion("receiver_province <", value, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceLessThanOrEqualTo(String value) {
            addCriterion("receiver_province <=", value, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceLike(String value) {
            addCriterion("receiver_province like", value, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceNotLike(String value) {
            addCriterion("receiver_province not like", value, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceIn(List<String> values) {
            addCriterion("receiver_province in", values, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceNotIn(List<String> values) {
            addCriterion("receiver_province not in", values, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceBetween(String value1, String value2) {
            addCriterion("receiver_province between", value1, value2, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverProvinceNotBetween(String value1, String value2) {
            addCriterion("receiver_province not between", value1, value2, "receiverProvince");
            return (Criteria) this;
        }

        public Criteria andReceiverCityIsNull() {
            addCriterion("receiver_city is null");
            return (Criteria) this;
        }

        public Criteria andReceiverCityIsNotNull() {
            addCriterion("receiver_city is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverCityEqualTo(String value) {
            addCriterion("receiver_city =", value, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityNotEqualTo(String value) {
            addCriterion("receiver_city <>", value, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityGreaterThan(String value) {
            addCriterion("receiver_city >", value, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_city >=", value, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityLessThan(String value) {
            addCriterion("receiver_city <", value, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityLessThanOrEqualTo(String value) {
            addCriterion("receiver_city <=", value, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityLike(String value) {
            addCriterion("receiver_city like", value, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityNotLike(String value) {
            addCriterion("receiver_city not like", value, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityIn(List<String> values) {
            addCriterion("receiver_city in", values, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityNotIn(List<String> values) {
            addCriterion("receiver_city not in", values, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityBetween(String value1, String value2) {
            addCriterion("receiver_city between", value1, value2, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverCityNotBetween(String value1, String value2) {
            addCriterion("receiver_city not between", value1, value2, "receiverCity");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictIsNull() {
            addCriterion("receiver_district is null");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictIsNotNull() {
            addCriterion("receiver_district is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictEqualTo(String value) {
            addCriterion("receiver_district =", value, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictNotEqualTo(String value) {
            addCriterion("receiver_district <>", value, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictGreaterThan(String value) {
            addCriterion("receiver_district >", value, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_district >=", value, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictLessThan(String value) {
            addCriterion("receiver_district <", value, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictLessThanOrEqualTo(String value) {
            addCriterion("receiver_district <=", value, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictLike(String value) {
            addCriterion("receiver_district like", value, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictNotLike(String value) {
            addCriterion("receiver_district not like", value, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictIn(List<String> values) {
            addCriterion("receiver_district in", values, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictNotIn(List<String> values) {
            addCriterion("receiver_district not in", values, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictBetween(String value1, String value2) {
            addCriterion("receiver_district between", value1, value2, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverDistrictNotBetween(String value1, String value2) {
            addCriterion("receiver_district not between", value1, value2, "receiverDistrict");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressIsNull() {
            addCriterion("receiver_address is null");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressIsNotNull() {
            addCriterion("receiver_address is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressEqualTo(String value) {
            addCriterion("receiver_address =", value, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressNotEqualTo(String value) {
            addCriterion("receiver_address <>", value, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressGreaterThan(String value) {
            addCriterion("receiver_address >", value, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_address >=", value, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressLessThan(String value) {
            addCriterion("receiver_address <", value, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressLessThanOrEqualTo(String value) {
            addCriterion("receiver_address <=", value, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressLike(String value) {
            addCriterion("receiver_address like", value, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressNotLike(String value) {
            addCriterion("receiver_address not like", value, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressIn(List<String> values) {
            addCriterion("receiver_address in", values, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressNotIn(List<String> values) {
            addCriterion("receiver_address not in", values, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressBetween(String value1, String value2) {
            addCriterion("receiver_address between", value1, value2, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverAddressNotBetween(String value1, String value2) {
            addCriterion("receiver_address not between", value1, value2, "receiverAddress");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileIsNull() {
            addCriterion("receiver_mobile is null");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileIsNotNull() {
            addCriterion("receiver_mobile is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileEqualTo(String value) {
            addCriterion("receiver_mobile =", value, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileNotEqualTo(String value) {
            addCriterion("receiver_mobile <>", value, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileGreaterThan(String value) {
            addCriterion("receiver_mobile >", value, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_mobile >=", value, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileLessThan(String value) {
            addCriterion("receiver_mobile <", value, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileLessThanOrEqualTo(String value) {
            addCriterion("receiver_mobile <=", value, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileLike(String value) {
            addCriterion("receiver_mobile like", value, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileNotLike(String value) {
            addCriterion("receiver_mobile not like", value, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileIn(List<String> values) {
            addCriterion("receiver_mobile in", values, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileNotIn(List<String> values) {
            addCriterion("receiver_mobile not in", values, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileBetween(String value1, String value2) {
            addCriterion("receiver_mobile between", value1, value2, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverMobileNotBetween(String value1, String value2) {
            addCriterion("receiver_mobile not between", value1, value2, "receiverMobile");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoIsNull() {
            addCriterion("receiver_telno is null");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoIsNotNull() {
            addCriterion("receiver_telno is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoEqualTo(String value) {
            addCriterion("receiver_telno =", value, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoNotEqualTo(String value) {
            addCriterion("receiver_telno <>", value, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoGreaterThan(String value) {
            addCriterion("receiver_telno >", value, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_telno >=", value, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoLessThan(String value) {
            addCriterion("receiver_telno <", value, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoLessThanOrEqualTo(String value) {
            addCriterion("receiver_telno <=", value, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoLike(String value) {
            addCriterion("receiver_telno like", value, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoNotLike(String value) {
            addCriterion("receiver_telno not like", value, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoIn(List<String> values) {
            addCriterion("receiver_telno in", values, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoNotIn(List<String> values) {
            addCriterion("receiver_telno not in", values, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoBetween(String value1, String value2) {
            addCriterion("receiver_telno between", value1, value2, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverTelnoNotBetween(String value1, String value2) {
            addCriterion("receiver_telno not between", value1, value2, "receiverTelno");
            return (Criteria) this;
        }

        public Criteria andReceiverZipIsNull() {
            addCriterion("receiver_zip is null");
            return (Criteria) this;
        }

        public Criteria andReceiverZipIsNotNull() {
            addCriterion("receiver_zip is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverZipEqualTo(String value) {
            addCriterion("receiver_zip =", value, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipNotEqualTo(String value) {
            addCriterion("receiver_zip <>", value, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipGreaterThan(String value) {
            addCriterion("receiver_zip >", value, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_zip >=", value, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipLessThan(String value) {
            addCriterion("receiver_zip <", value, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipLessThanOrEqualTo(String value) {
            addCriterion("receiver_zip <=", value, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipLike(String value) {
            addCriterion("receiver_zip like", value, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipNotLike(String value) {
            addCriterion("receiver_zip not like", value, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipIn(List<String> values) {
            addCriterion("receiver_zip in", values, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipNotIn(List<String> values) {
            addCriterion("receiver_zip not in", values, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipBetween(String value1, String value2) {
            addCriterion("receiver_zip between", value1, value2, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverZipNotBetween(String value1, String value2) {
            addCriterion("receiver_zip not between", value1, value2, "receiverZip");
            return (Criteria) this;
        }

        public Criteria andReceiverAreaIsNull() {
            addCriterion("receiver_area is null");
            return (Criteria) this;
        }

        public Criteria andReceiverAreaIsNotNull() {
            addCriterion("receiver_area is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverAreaEqualTo(String value) {
            addCriterion("receiver_area =", value, "receiverArea");
            return (Criteria) this;
        }

        public Criteria andReceiverAreaNotEqualTo(String value) {
            addCriterion("receiver_area <>", value, "receiverArea");
            return (Criteria) this;
        }

        public Criteria andReceiverAreaGreaterThan(String value) {
            addCriterion("receiver_area >", value, "receiverArea");
            return (Criteria) this;
        }

        public Criteria andReceiverAreaGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_area >=", value, "receiverArea");
            return (Criteria) this;
        }

        public Criteria andReceiverAreaLessThan(String value) {
            addCriterion("receiver_area <", value, "receiverArea");
            return (Criteria) this;
        }

        public Criteria andReceiverAreaLessThanOrEqualTo(String value) {
            addCriterion("receiver_area <=", value, "receiverArea");
            return (Criteria) this;
        }

        public Criteria andReceiverAreaLike(String value) {
            addCriterion("receiver_area like", value, "receiverArea");
            return (Criteria) this;
        }

        public Criteria andReceiverAreaNotLike(String value) {
            addCriterion("receiver_area not like", value, "receiverArea");
            return (Criteria) this;
        }

        public Criteria andReceiverAreaIn(List<String> values) {
            addCriterion("receiver_area in", values, "receiverArea");
            return (Criteria) this;
        }

        public Criteria andReceiverAreaNotIn(List<String> values) {
            addCriterion("receiver_area not in", values, "receiverArea");
            return (Criteria) this;
        }

        public Criteria andReceiverAreaBetween(String value1, String value2) {
            addCriterion("receiver_area between", value1, value2, "receiverArea");
            return (Criteria) this;
        }

        public Criteria andReceiverAreaNotBetween(String value1, String value2) {
            addCriterion("receiver_area not between", value1, value2, "receiverArea");
            return (Criteria) this;
        }

        public Criteria andReceiverRingIsNull() {
            addCriterion("receiver_ring is null");
            return (Criteria) this;
        }

        public Criteria andReceiverRingIsNotNull() {
            addCriterion("receiver_ring is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverRingEqualTo(String value) {
            addCriterion("receiver_ring =", value, "receiverRing");
            return (Criteria) this;
        }

        public Criteria andReceiverRingNotEqualTo(String value) {
            addCriterion("receiver_ring <>", value, "receiverRing");
            return (Criteria) this;
        }

        public Criteria andReceiverRingGreaterThan(String value) {
            addCriterion("receiver_ring >", value, "receiverRing");
            return (Criteria) this;
        }

        public Criteria andReceiverRingGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_ring >=", value, "receiverRing");
            return (Criteria) this;
        }

        public Criteria andReceiverRingLessThan(String value) {
            addCriterion("receiver_ring <", value, "receiverRing");
            return (Criteria) this;
        }

        public Criteria andReceiverRingLessThanOrEqualTo(String value) {
            addCriterion("receiver_ring <=", value, "receiverRing");
            return (Criteria) this;
        }

        public Criteria andReceiverRingLike(String value) {
            addCriterion("receiver_ring like", value, "receiverRing");
            return (Criteria) this;
        }

        public Criteria andReceiverRingNotLike(String value) {
            addCriterion("receiver_ring not like", value, "receiverRing");
            return (Criteria) this;
        }

        public Criteria andReceiverRingIn(List<String> values) {
            addCriterion("receiver_ring in", values, "receiverRing");
            return (Criteria) this;
        }

        public Criteria andReceiverRingNotIn(List<String> values) {
            addCriterion("receiver_ring not in", values, "receiverRing");
            return (Criteria) this;
        }

        public Criteria andReceiverRingBetween(String value1, String value2) {
            addCriterion("receiver_ring between", value1, value2, "receiverRing");
            return (Criteria) this;
        }

        public Criteria andReceiverRingNotBetween(String value1, String value2) {
            addCriterion("receiver_ring not between", value1, value2, "receiverRing");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbIsNull() {
            addCriterion("receiver_dtb is null");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbIsNotNull() {
            addCriterion("receiver_dtb is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbEqualTo(String value) {
            addCriterion("receiver_dtb =", value, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbNotEqualTo(String value) {
            addCriterion("receiver_dtb <>", value, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbGreaterThan(String value) {
            addCriterion("receiver_dtb >", value, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbGreaterThanOrEqualTo(String value) {
            addCriterion("receiver_dtb >=", value, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbLessThan(String value) {
            addCriterion("receiver_dtb <", value, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbLessThanOrEqualTo(String value) {
            addCriterion("receiver_dtb <=", value, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbLike(String value) {
            addCriterion("receiver_dtb like", value, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbNotLike(String value) {
            addCriterion("receiver_dtb not like", value, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbIn(List<String> values) {
            addCriterion("receiver_dtb in", values, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbNotIn(List<String> values) {
            addCriterion("receiver_dtb not in", values, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbBetween(String value1, String value2) {
            addCriterion("receiver_dtb between", value1, value2, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andReceiverDtbNotBetween(String value1, String value2) {
            addCriterion("receiver_dtb not between", value1, value2, "receiverDtb");
            return (Criteria) this;
        }

        public Criteria andToDeliverTimeIsNull() {
            addCriterion("to_deliver_time is null");
            return (Criteria) this;
        }

        public Criteria andToDeliverTimeIsNotNull() {
            addCriterion("to_deliver_time is not null");
            return (Criteria) this;
        }

        public Criteria andToDeliverTimeEqualTo(String value) {
            addCriterion("to_deliver_time =", value, "toDeliverTime");
            return (Criteria) this;
        }

        public Criteria andToDeliverTimeNotEqualTo(String value) {
            addCriterion("to_deliver_time <>", value, "toDeliverTime");
            return (Criteria) this;
        }

        public Criteria andToDeliverTimeGreaterThan(String value) {
            addCriterion("to_deliver_time >", value, "toDeliverTime");
            return (Criteria) this;
        }

        public Criteria andToDeliverTimeGreaterThanOrEqualTo(String value) {
            addCriterion("to_deliver_time >=", value, "toDeliverTime");
            return (Criteria) this;
        }

        public Criteria andToDeliverTimeLessThan(String value) {
            addCriterion("to_deliver_time <", value, "toDeliverTime");
            return (Criteria) this;
        }

        public Criteria andToDeliverTimeLessThanOrEqualTo(String value) {
            addCriterion("to_deliver_time <=", value, "toDeliverTime");
            return (Criteria) this;
        }

        public Criteria andToDeliverTimeLike(String value) {
            addCriterion("to_deliver_time like", value, "toDeliverTime");
            return (Criteria) this;
        }

        public Criteria andToDeliverTimeNotLike(String value) {
            addCriterion("to_deliver_time not like", value, "toDeliverTime");
            return (Criteria) this;
        }

        public Criteria andToDeliverTimeIn(List<String> values) {
            addCriterion("to_deliver_time in", values, "toDeliverTime");
            return (Criteria) this;
        }

        public Criteria andToDeliverTimeNotIn(List<String> values) {
            addCriterion("to_deliver_time not in", values, "toDeliverTime");
            return (Criteria) this;
        }

        public Criteria andToDeliverTimeBetween(String value1, String value2) {
            addCriterion("to_deliver_time between", value1, value2, "toDeliverTime");
            return (Criteria) this;
        }

        public Criteria andToDeliverTimeNotBetween(String value1, String value2) {
            addCriterion("to_deliver_time not between", value1, value2, "toDeliverTime");
            return (Criteria) this;
        }

        public Criteria andLogisticsIdIsNull() {
            addCriterion("logistics_id is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsIdIsNotNull() {
            addCriterion("logistics_id is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsIdEqualTo(Integer value) {
            addCriterion("logistics_id =", value, "logisticsId");
            return (Criteria) this;
        }

        public Criteria andLogisticsIdNotEqualTo(Integer value) {
            addCriterion("logistics_id <>", value, "logisticsId");
            return (Criteria) this;
        }

        public Criteria andLogisticsIdGreaterThan(Integer value) {
            addCriterion("logistics_id >", value, "logisticsId");
            return (Criteria) this;
        }

        public Criteria andLogisticsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("logistics_id >=", value, "logisticsId");
            return (Criteria) this;
        }

        public Criteria andLogisticsIdLessThan(Integer value) {
            addCriterion("logistics_id <", value, "logisticsId");
            return (Criteria) this;
        }

        public Criteria andLogisticsIdLessThanOrEqualTo(Integer value) {
            addCriterion("logistics_id <=", value, "logisticsId");
            return (Criteria) this;
        }

        public Criteria andLogisticsIdIn(List<Integer> values) {
            addCriterion("logistics_id in", values, "logisticsId");
            return (Criteria) this;
        }

        public Criteria andLogisticsIdNotIn(List<Integer> values) {
            addCriterion("logistics_id not in", values, "logisticsId");
            return (Criteria) this;
        }

        public Criteria andLogisticsIdBetween(Integer value1, Integer value2) {
            addCriterion("logistics_id between", value1, value2, "logisticsId");
            return (Criteria) this;
        }

        public Criteria andLogisticsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("logistics_id not between", value1, value2, "logisticsId");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameIsNull() {
            addCriterion("logistics_name is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameIsNotNull() {
            addCriterion("logistics_name is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameEqualTo(String value) {
            addCriterion("logistics_name =", value, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameNotEqualTo(String value) {
            addCriterion("logistics_name <>", value, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameGreaterThan(String value) {
            addCriterion("logistics_name >", value, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameGreaterThanOrEqualTo(String value) {
            addCriterion("logistics_name >=", value, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameLessThan(String value) {
            addCriterion("logistics_name <", value, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameLessThanOrEqualTo(String value) {
            addCriterion("logistics_name <=", value, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameLike(String value) {
            addCriterion("logistics_name like", value, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameNotLike(String value) {
            addCriterion("logistics_name not like", value, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameIn(List<String> values) {
            addCriterion("logistics_name in", values, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameNotIn(List<String> values) {
            addCriterion("logistics_name not in", values, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameBetween(String value1, String value2) {
            addCriterion("logistics_name between", value1, value2, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsNameNotBetween(String value1, String value2) {
            addCriterion("logistics_name not between", value1, value2, "logisticsName");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeIsNull() {
            addCriterion("logistics_code is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeIsNotNull() {
            addCriterion("logistics_code is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeEqualTo(String value) {
            addCriterion("logistics_code =", value, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeNotEqualTo(String value) {
            addCriterion("logistics_code <>", value, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeGreaterThan(String value) {
            addCriterion("logistics_code >", value, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeGreaterThanOrEqualTo(String value) {
            addCriterion("logistics_code >=", value, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeLessThan(String value) {
            addCriterion("logistics_code <", value, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeLessThanOrEqualTo(String value) {
            addCriterion("logistics_code <=", value, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeLike(String value) {
            addCriterion("logistics_code like", value, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeNotLike(String value) {
            addCriterion("logistics_code not like", value, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeIn(List<String> values) {
            addCriterion("logistics_code in", values, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeNotIn(List<String> values) {
            addCriterion("logistics_code not in", values, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeBetween(String value1, String value2) {
            addCriterion("logistics_code between", value1, value2, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsCodeNotBetween(String value1, String value2) {
            addCriterion("logistics_code not between", value1, value2, "logisticsCode");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeIsNull() {
            addCriterion("logistics_type is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeIsNotNull() {
            addCriterion("logistics_type is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeEqualTo(Integer value) {
            addCriterion("logistics_type =", value, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeNotEqualTo(Integer value) {
            addCriterion("logistics_type <>", value, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeGreaterThan(Integer value) {
            addCriterion("logistics_type >", value, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("logistics_type >=", value, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeLessThan(Integer value) {
            addCriterion("logistics_type <", value, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeLessThanOrEqualTo(Integer value) {
            addCriterion("logistics_type <=", value, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeIn(List<Integer> values) {
            addCriterion("logistics_type in", values, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeNotIn(List<Integer> values) {
            addCriterion("logistics_type not in", values, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeBetween(Integer value1, Integer value2) {
            addCriterion("logistics_type between", value1, value2, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("logistics_type not between", value1, value2, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoIsNull() {
            addCriterion("logistics_no is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoIsNotNull() {
            addCriterion("logistics_no is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoEqualTo(String value) {
            addCriterion("logistics_no =", value, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoNotEqualTo(String value) {
            addCriterion("logistics_no <>", value, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoGreaterThan(String value) {
            addCriterion("logistics_no >", value, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoGreaterThanOrEqualTo(String value) {
            addCriterion("logistics_no >=", value, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoLessThan(String value) {
            addCriterion("logistics_no <", value, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoLessThanOrEqualTo(String value) {
            addCriterion("logistics_no <=", value, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoLike(String value) {
            addCriterion("logistics_no like", value, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoNotLike(String value) {
            addCriterion("logistics_no not like", value, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoIn(List<String> values) {
            addCriterion("logistics_no in", values, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoNotIn(List<String> values) {
            addCriterion("logistics_no not in", values, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoBetween(String value1, String value2) {
            addCriterion("logistics_no between", value1, value2, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andLogisticsNoNotBetween(String value1, String value2) {
            addCriterion("logistics_no not between", value1, value2, "logisticsNo");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageIsNull() {
            addCriterion("buyer_message is null");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageIsNotNull() {
            addCriterion("buyer_message is not null");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageEqualTo(String value) {
            addCriterion("buyer_message =", value, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageNotEqualTo(String value) {
            addCriterion("buyer_message <>", value, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageGreaterThan(String value) {
            addCriterion("buyer_message >", value, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageGreaterThanOrEqualTo(String value) {
            addCriterion("buyer_message >=", value, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageLessThan(String value) {
            addCriterion("buyer_message <", value, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageLessThanOrEqualTo(String value) {
            addCriterion("buyer_message <=", value, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageLike(String value) {
            addCriterion("buyer_message like", value, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageNotLike(String value) {
            addCriterion("buyer_message not like", value, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageIn(List<String> values) {
            addCriterion("buyer_message in", values, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageNotIn(List<String> values) {
            addCriterion("buyer_message not in", values, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageBetween(String value1, String value2) {
            addCriterion("buyer_message between", value1, value2, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andBuyerMessageNotBetween(String value1, String value2) {
            addCriterion("buyer_message not between", value1, value2, "buyerMessage");
            return (Criteria) this;
        }

        public Criteria andCsRemarkIsNull() {
            addCriterion("cs_remark is null");
            return (Criteria) this;
        }

        public Criteria andCsRemarkIsNotNull() {
            addCriterion("cs_remark is not null");
            return (Criteria) this;
        }

        public Criteria andCsRemarkEqualTo(String value) {
            addCriterion("cs_remark =", value, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkNotEqualTo(String value) {
            addCriterion("cs_remark <>", value, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkGreaterThan(String value) {
            addCriterion("cs_remark >", value, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("cs_remark >=", value, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkLessThan(String value) {
            addCriterion("cs_remark <", value, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkLessThanOrEqualTo(String value) {
            addCriterion("cs_remark <=", value, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkLike(String value) {
            addCriterion("cs_remark like", value, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkNotLike(String value) {
            addCriterion("cs_remark not like", value, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkIn(List<String> values) {
            addCriterion("cs_remark in", values, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkNotIn(List<String> values) {
            addCriterion("cs_remark not in", values, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkBetween(String value1, String value2) {
            addCriterion("cs_remark between", value1, value2, "csRemark");
            return (Criteria) this;
        }

        public Criteria andCsRemarkNotBetween(String value1, String value2) {
            addCriterion("cs_remark not between", value1, value2, "csRemark");
            return (Criteria) this;
        }

        public Criteria andRemarkFlagIsNull() {
            addCriterion("remark_flag is null");
            return (Criteria) this;
        }

        public Criteria andRemarkFlagIsNotNull() {
            addCriterion("remark_flag is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkFlagEqualTo(Integer value) {
            addCriterion("remark_flag =", value, "remarkFlag");
            return (Criteria) this;
        }

        public Criteria andRemarkFlagNotEqualTo(Integer value) {
            addCriterion("remark_flag <>", value, "remarkFlag");
            return (Criteria) this;
        }

        public Criteria andRemarkFlagGreaterThan(Integer value) {
            addCriterion("remark_flag >", value, "remarkFlag");
            return (Criteria) this;
        }

        public Criteria andRemarkFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("remark_flag >=", value, "remarkFlag");
            return (Criteria) this;
        }

        public Criteria andRemarkFlagLessThan(Integer value) {
            addCriterion("remark_flag <", value, "remarkFlag");
            return (Criteria) this;
        }

        public Criteria andRemarkFlagLessThanOrEqualTo(Integer value) {
            addCriterion("remark_flag <=", value, "remarkFlag");
            return (Criteria) this;
        }

        public Criteria andRemarkFlagIn(List<Integer> values) {
            addCriterion("remark_flag in", values, "remarkFlag");
            return (Criteria) this;
        }

        public Criteria andRemarkFlagNotIn(List<Integer> values) {
            addCriterion("remark_flag not in", values, "remarkFlag");
            return (Criteria) this;
        }

        public Criteria andRemarkFlagBetween(Integer value1, Integer value2) {
            addCriterion("remark_flag between", value1, value2, "remarkFlag");
            return (Criteria) this;
        }

        public Criteria andRemarkFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("remark_flag not between", value1, value2, "remarkFlag");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkIsNull() {
            addCriterion("print_remark is null");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkIsNotNull() {
            addCriterion("print_remark is not null");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkEqualTo(String value) {
            addCriterion("print_remark =", value, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkNotEqualTo(String value) {
            addCriterion("print_remark <>", value, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkGreaterThan(String value) {
            addCriterion("print_remark >", value, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("print_remark >=", value, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkLessThan(String value) {
            addCriterion("print_remark <", value, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkLessThanOrEqualTo(String value) {
            addCriterion("print_remark <=", value, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkLike(String value) {
            addCriterion("print_remark like", value, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkNotLike(String value) {
            addCriterion("print_remark not like", value, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkIn(List<String> values) {
            addCriterion("print_remark in", values, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkNotIn(List<String> values) {
            addCriterion("print_remark not in", values, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkBetween(String value1, String value2) {
            addCriterion("print_remark between", value1, value2, "printRemark");
            return (Criteria) this;
        }

        public Criteria andPrintRemarkNotBetween(String value1, String value2) {
            addCriterion("print_remark not between", value1, value2, "printRemark");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeCountIsNull() {
            addCriterion("goods_type_count is null");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeCountIsNotNull() {
            addCriterion("goods_type_count is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeCountEqualTo(Integer value) {
            addCriterion("goods_type_count =", value, "goodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeCountNotEqualTo(Integer value) {
            addCriterion("goods_type_count <>", value, "goodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeCountGreaterThan(Integer value) {
            addCriterion("goods_type_count >", value, "goodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeCountGreaterThanOrEqualTo(Integer value) {
            addCriterion("goods_type_count >=", value, "goodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeCountLessThan(Integer value) {
            addCriterion("goods_type_count <", value, "goodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeCountLessThanOrEqualTo(Integer value) {
            addCriterion("goods_type_count <=", value, "goodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeCountIn(List<Integer> values) {
            addCriterion("goods_type_count in", values, "goodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeCountNotIn(List<Integer> values) {
            addCriterion("goods_type_count not in", values, "goodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeCountBetween(Integer value1, Integer value2) {
            addCriterion("goods_type_count between", value1, value2, "goodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andGoodsTypeCountNotBetween(Integer value1, Integer value2) {
            addCriterion("goods_type_count not between", value1, value2, "goodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountIsNull() {
            addCriterion("goods_count is null");
            return (Criteria) this;
        }

        public Criteria andGoodsCountIsNotNull() {
            addCriterion("goods_count is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsCountEqualTo(BigDecimal value) {
            addCriterion("goods_count =", value, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountNotEqualTo(BigDecimal value) {
            addCriterion("goods_count <>", value, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountGreaterThan(BigDecimal value) {
            addCriterion("goods_count >", value, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_count >=", value, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountLessThan(BigDecimal value) {
            addCriterion("goods_count <", value, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_count <=", value, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountIn(List<BigDecimal> values) {
            addCriterion("goods_count in", values, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountNotIn(List<BigDecimal> values) {
            addCriterion("goods_count not in", values, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_count between", value1, value2, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_count not between", value1, value2, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountIsNull() {
            addCriterion("goods_amount is null");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountIsNotNull() {
            addCriterion("goods_amount is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountEqualTo(BigDecimal value) {
            addCriterion("goods_amount =", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountNotEqualTo(BigDecimal value) {
            addCriterion("goods_amount <>", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountGreaterThan(BigDecimal value) {
            addCriterion("goods_amount >", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_amount >=", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountLessThan(BigDecimal value) {
            addCriterion("goods_amount <", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_amount <=", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountIn(List<BigDecimal> values) {
            addCriterion("goods_amount in", values, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountNotIn(List<BigDecimal> values) {
            addCriterion("goods_amount not in", values, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_amount between", value1, value2, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_amount not between", value1, value2, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andPostAmountIsNull() {
            addCriterion("post_amount is null");
            return (Criteria) this;
        }

        public Criteria andPostAmountIsNotNull() {
            addCriterion("post_amount is not null");
            return (Criteria) this;
        }

        public Criteria andPostAmountEqualTo(BigDecimal value) {
            addCriterion("post_amount =", value, "postAmount");
            return (Criteria) this;
        }

        public Criteria andPostAmountNotEqualTo(BigDecimal value) {
            addCriterion("post_amount <>", value, "postAmount");
            return (Criteria) this;
        }

        public Criteria andPostAmountGreaterThan(BigDecimal value) {
            addCriterion("post_amount >", value, "postAmount");
            return (Criteria) this;
        }

        public Criteria andPostAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("post_amount >=", value, "postAmount");
            return (Criteria) this;
        }

        public Criteria andPostAmountLessThan(BigDecimal value) {
            addCriterion("post_amount <", value, "postAmount");
            return (Criteria) this;
        }

        public Criteria andPostAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("post_amount <=", value, "postAmount");
            return (Criteria) this;
        }

        public Criteria andPostAmountIn(List<BigDecimal> values) {
            addCriterion("post_amount in", values, "postAmount");
            return (Criteria) this;
        }

        public Criteria andPostAmountNotIn(List<BigDecimal> values) {
            addCriterion("post_amount not in", values, "postAmount");
            return (Criteria) this;
        }

        public Criteria andPostAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("post_amount between", value1, value2, "postAmount");
            return (Criteria) this;
        }

        public Criteria andPostAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("post_amount not between", value1, value2, "postAmount");
            return (Criteria) this;
        }

        public Criteria andOtherAmountIsNull() {
            addCriterion("other_amount is null");
            return (Criteria) this;
        }

        public Criteria andOtherAmountIsNotNull() {
            addCriterion("other_amount is not null");
            return (Criteria) this;
        }

        public Criteria andOtherAmountEqualTo(BigDecimal value) {
            addCriterion("other_amount =", value, "otherAmount");
            return (Criteria) this;
        }

        public Criteria andOtherAmountNotEqualTo(BigDecimal value) {
            addCriterion("other_amount <>", value, "otherAmount");
            return (Criteria) this;
        }

        public Criteria andOtherAmountGreaterThan(BigDecimal value) {
            addCriterion("other_amount >", value, "otherAmount");
            return (Criteria) this;
        }

        public Criteria andOtherAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("other_amount >=", value, "otherAmount");
            return (Criteria) this;
        }

        public Criteria andOtherAmountLessThan(BigDecimal value) {
            addCriterion("other_amount <", value, "otherAmount");
            return (Criteria) this;
        }

        public Criteria andOtherAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("other_amount <=", value, "otherAmount");
            return (Criteria) this;
        }

        public Criteria andOtherAmountIn(List<BigDecimal> values) {
            addCriterion("other_amount in", values, "otherAmount");
            return (Criteria) this;
        }

        public Criteria andOtherAmountNotIn(List<BigDecimal> values) {
            addCriterion("other_amount not in", values, "otherAmount");
            return (Criteria) this;
        }

        public Criteria andOtherAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("other_amount between", value1, value2, "otherAmount");
            return (Criteria) this;
        }

        public Criteria andOtherAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("other_amount not between", value1, value2, "otherAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNull() {
            addCriterion("discount is null");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNotNull() {
            addCriterion("discount is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountEqualTo(BigDecimal value) {
            addCriterion("discount =", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotEqualTo(BigDecimal value) {
            addCriterion("discount <>", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThan(BigDecimal value) {
            addCriterion("discount >", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discount >=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThan(BigDecimal value) {
            addCriterion("discount <", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discount <=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountIn(List<BigDecimal> values) {
            addCriterion("discount in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotIn(List<BigDecimal> values) {
            addCriterion("discount not in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discount between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discount not between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andReceivableIsNull() {
            addCriterion("receivable is null");
            return (Criteria) this;
        }

        public Criteria andReceivableIsNotNull() {
            addCriterion("receivable is not null");
            return (Criteria) this;
        }

        public Criteria andReceivableEqualTo(BigDecimal value) {
            addCriterion("receivable =", value, "receivable");
            return (Criteria) this;
        }

        public Criteria andReceivableNotEqualTo(BigDecimal value) {
            addCriterion("receivable <>", value, "receivable");
            return (Criteria) this;
        }

        public Criteria andReceivableGreaterThan(BigDecimal value) {
            addCriterion("receivable >", value, "receivable");
            return (Criteria) this;
        }

        public Criteria andReceivableGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("receivable >=", value, "receivable");
            return (Criteria) this;
        }

        public Criteria andReceivableLessThan(BigDecimal value) {
            addCriterion("receivable <", value, "receivable");
            return (Criteria) this;
        }

        public Criteria andReceivableLessThanOrEqualTo(BigDecimal value) {
            addCriterion("receivable <=", value, "receivable");
            return (Criteria) this;
        }

        public Criteria andReceivableIn(List<BigDecimal> values) {
            addCriterion("receivable in", values, "receivable");
            return (Criteria) this;
        }

        public Criteria andReceivableNotIn(List<BigDecimal> values) {
            addCriterion("receivable not in", values, "receivable");
            return (Criteria) this;
        }

        public Criteria andReceivableBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("receivable between", value1, value2, "receivable");
            return (Criteria) this;
        }

        public Criteria andReceivableNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("receivable not between", value1, value2, "receivable");
            return (Criteria) this;
        }

        public Criteria andDapAmountIsNull() {
            addCriterion("dap_amount is null");
            return (Criteria) this;
        }

        public Criteria andDapAmountIsNotNull() {
            addCriterion("dap_amount is not null");
            return (Criteria) this;
        }

        public Criteria andDapAmountEqualTo(BigDecimal value) {
            addCriterion("dap_amount =", value, "dapAmount");
            return (Criteria) this;
        }

        public Criteria andDapAmountNotEqualTo(BigDecimal value) {
            addCriterion("dap_amount <>", value, "dapAmount");
            return (Criteria) this;
        }

        public Criteria andDapAmountGreaterThan(BigDecimal value) {
            addCriterion("dap_amount >", value, "dapAmount");
            return (Criteria) this;
        }

        public Criteria andDapAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("dap_amount >=", value, "dapAmount");
            return (Criteria) this;
        }

        public Criteria andDapAmountLessThan(BigDecimal value) {
            addCriterion("dap_amount <", value, "dapAmount");
            return (Criteria) this;
        }

        public Criteria andDapAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("dap_amount <=", value, "dapAmount");
            return (Criteria) this;
        }

        public Criteria andDapAmountIn(List<BigDecimal> values) {
            addCriterion("dap_amount in", values, "dapAmount");
            return (Criteria) this;
        }

        public Criteria andDapAmountNotIn(List<BigDecimal> values) {
            addCriterion("dap_amount not in", values, "dapAmount");
            return (Criteria) this;
        }

        public Criteria andDapAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("dap_amount between", value1, value2, "dapAmount");
            return (Criteria) this;
        }

        public Criteria andDapAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("dap_amount not between", value1, value2, "dapAmount");
            return (Criteria) this;
        }

        public Criteria andCodAmountIsNull() {
            addCriterion("cod_amount is null");
            return (Criteria) this;
        }

        public Criteria andCodAmountIsNotNull() {
            addCriterion("cod_amount is not null");
            return (Criteria) this;
        }

        public Criteria andCodAmountEqualTo(BigDecimal value) {
            addCriterion("cod_amount =", value, "codAmount");
            return (Criteria) this;
        }

        public Criteria andCodAmountNotEqualTo(BigDecimal value) {
            addCriterion("cod_amount <>", value, "codAmount");
            return (Criteria) this;
        }

        public Criteria andCodAmountGreaterThan(BigDecimal value) {
            addCriterion("cod_amount >", value, "codAmount");
            return (Criteria) this;
        }

        public Criteria andCodAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("cod_amount >=", value, "codAmount");
            return (Criteria) this;
        }

        public Criteria andCodAmountLessThan(BigDecimal value) {
            addCriterion("cod_amount <", value, "codAmount");
            return (Criteria) this;
        }

        public Criteria andCodAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("cod_amount <=", value, "codAmount");
            return (Criteria) this;
        }

        public Criteria andCodAmountIn(List<BigDecimal> values) {
            addCriterion("cod_amount in", values, "codAmount");
            return (Criteria) this;
        }

        public Criteria andCodAmountNotIn(List<BigDecimal> values) {
            addCriterion("cod_amount not in", values, "codAmount");
            return (Criteria) this;
        }

        public Criteria andCodAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cod_amount between", value1, value2, "codAmount");
            return (Criteria) this;
        }

        public Criteria andCodAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cod_amount not between", value1, value2, "codAmount");
            return (Criteria) this;
        }

        public Criteria andExtCodFeeIsNull() {
            addCriterion("ext_cod_fee is null");
            return (Criteria) this;
        }

        public Criteria andExtCodFeeIsNotNull() {
            addCriterion("ext_cod_fee is not null");
            return (Criteria) this;
        }

        public Criteria andExtCodFeeEqualTo(BigDecimal value) {
            addCriterion("ext_cod_fee =", value, "extCodFee");
            return (Criteria) this;
        }

        public Criteria andExtCodFeeNotEqualTo(BigDecimal value) {
            addCriterion("ext_cod_fee <>", value, "extCodFee");
            return (Criteria) this;
        }

        public Criteria andExtCodFeeGreaterThan(BigDecimal value) {
            addCriterion("ext_cod_fee >", value, "extCodFee");
            return (Criteria) this;
        }

        public Criteria andExtCodFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ext_cod_fee >=", value, "extCodFee");
            return (Criteria) this;
        }

        public Criteria andExtCodFeeLessThan(BigDecimal value) {
            addCriterion("ext_cod_fee <", value, "extCodFee");
            return (Criteria) this;
        }

        public Criteria andExtCodFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ext_cod_fee <=", value, "extCodFee");
            return (Criteria) this;
        }

        public Criteria andExtCodFeeIn(List<BigDecimal> values) {
            addCriterion("ext_cod_fee in", values, "extCodFee");
            return (Criteria) this;
        }

        public Criteria andExtCodFeeNotIn(List<BigDecimal> values) {
            addCriterion("ext_cod_fee not in", values, "extCodFee");
            return (Criteria) this;
        }

        public Criteria andExtCodFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ext_cod_fee between", value1, value2, "extCodFee");
            return (Criteria) this;
        }

        public Criteria andExtCodFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ext_cod_fee not between", value1, value2, "extCodFee");
            return (Criteria) this;
        }

        public Criteria andGoodsCostIsNull() {
            addCriterion("goods_cost is null");
            return (Criteria) this;
        }

        public Criteria andGoodsCostIsNotNull() {
            addCriterion("goods_cost is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsCostEqualTo(BigDecimal value) {
            addCriterion("goods_cost =", value, "goodsCost");
            return (Criteria) this;
        }

        public Criteria andGoodsCostNotEqualTo(BigDecimal value) {
            addCriterion("goods_cost <>", value, "goodsCost");
            return (Criteria) this;
        }

        public Criteria andGoodsCostGreaterThan(BigDecimal value) {
            addCriterion("goods_cost >", value, "goodsCost");
            return (Criteria) this;
        }

        public Criteria andGoodsCostGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_cost >=", value, "goodsCost");
            return (Criteria) this;
        }

        public Criteria andGoodsCostLessThan(BigDecimal value) {
            addCriterion("goods_cost <", value, "goodsCost");
            return (Criteria) this;
        }

        public Criteria andGoodsCostLessThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_cost <=", value, "goodsCost");
            return (Criteria) this;
        }

        public Criteria andGoodsCostIn(List<BigDecimal> values) {
            addCriterion("goods_cost in", values, "goodsCost");
            return (Criteria) this;
        }

        public Criteria andGoodsCostNotIn(List<BigDecimal> values) {
            addCriterion("goods_cost not in", values, "goodsCost");
            return (Criteria) this;
        }

        public Criteria andGoodsCostBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_cost between", value1, value2, "goodsCost");
            return (Criteria) this;
        }

        public Criteria andGoodsCostNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_cost not between", value1, value2, "goodsCost");
            return (Criteria) this;
        }

        public Criteria andPostCostIsNull() {
            addCriterion("post_cost is null");
            return (Criteria) this;
        }

        public Criteria andPostCostIsNotNull() {
            addCriterion("post_cost is not null");
            return (Criteria) this;
        }

        public Criteria andPostCostEqualTo(BigDecimal value) {
            addCriterion("post_cost =", value, "postCost");
            return (Criteria) this;
        }

        public Criteria andPostCostNotEqualTo(BigDecimal value) {
            addCriterion("post_cost <>", value, "postCost");
            return (Criteria) this;
        }

        public Criteria andPostCostGreaterThan(BigDecimal value) {
            addCriterion("post_cost >", value, "postCost");
            return (Criteria) this;
        }

        public Criteria andPostCostGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("post_cost >=", value, "postCost");
            return (Criteria) this;
        }

        public Criteria andPostCostLessThan(BigDecimal value) {
            addCriterion("post_cost <", value, "postCost");
            return (Criteria) this;
        }

        public Criteria andPostCostLessThanOrEqualTo(BigDecimal value) {
            addCriterion("post_cost <=", value, "postCost");
            return (Criteria) this;
        }

        public Criteria andPostCostIn(List<BigDecimal> values) {
            addCriterion("post_cost in", values, "postCost");
            return (Criteria) this;
        }

        public Criteria andPostCostNotIn(List<BigDecimal> values) {
            addCriterion("post_cost not in", values, "postCost");
            return (Criteria) this;
        }

        public Criteria andPostCostBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("post_cost between", value1, value2, "postCost");
            return (Criteria) this;
        }

        public Criteria andPostCostNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("post_cost not between", value1, value2, "postCost");
            return (Criteria) this;
        }

        public Criteria andPaidIsNull() {
            addCriterion("paid is null");
            return (Criteria) this;
        }

        public Criteria andPaidIsNotNull() {
            addCriterion("paid is not null");
            return (Criteria) this;
        }

        public Criteria andPaidEqualTo(BigDecimal value) {
            addCriterion("paid =", value, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidNotEqualTo(BigDecimal value) {
            addCriterion("paid <>", value, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidGreaterThan(BigDecimal value) {
            addCriterion("paid >", value, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("paid >=", value, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidLessThan(BigDecimal value) {
            addCriterion("paid <", value, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidLessThanOrEqualTo(BigDecimal value) {
            addCriterion("paid <=", value, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidIn(List<BigDecimal> values) {
            addCriterion("paid in", values, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidNotIn(List<BigDecimal> values) {
            addCriterion("paid not in", values, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("paid between", value1, value2, "paid");
            return (Criteria) this;
        }

        public Criteria andPaidNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("paid not between", value1, value2, "paid");
            return (Criteria) this;
        }

        public Criteria andWeightIsNull() {
            addCriterion("weight is null");
            return (Criteria) this;
        }

        public Criteria andWeightIsNotNull() {
            addCriterion("weight is not null");
            return (Criteria) this;
        }

        public Criteria andWeightEqualTo(BigDecimal value) {
            addCriterion("weight =", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotEqualTo(BigDecimal value) {
            addCriterion("weight <>", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThan(BigDecimal value) {
            addCriterion("weight >", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("weight >=", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightLessThan(BigDecimal value) {
            addCriterion("weight <", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("weight <=", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightIn(List<BigDecimal> values) {
            addCriterion("weight in", values, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotIn(List<BigDecimal> values) {
            addCriterion("weight not in", values, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("weight between", value1, value2, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("weight not between", value1, value2, "weight");
            return (Criteria) this;
        }

        public Criteria andProfitIsNull() {
            addCriterion("profit is null");
            return (Criteria) this;
        }

        public Criteria andProfitIsNotNull() {
            addCriterion("profit is not null");
            return (Criteria) this;
        }

        public Criteria andProfitEqualTo(BigDecimal value) {
            addCriterion("profit =", value, "profit");
            return (Criteria) this;
        }

        public Criteria andProfitNotEqualTo(BigDecimal value) {
            addCriterion("profit <>", value, "profit");
            return (Criteria) this;
        }

        public Criteria andProfitGreaterThan(BigDecimal value) {
            addCriterion("profit >", value, "profit");
            return (Criteria) this;
        }

        public Criteria andProfitGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("profit >=", value, "profit");
            return (Criteria) this;
        }

        public Criteria andProfitLessThan(BigDecimal value) {
            addCriterion("profit <", value, "profit");
            return (Criteria) this;
        }

        public Criteria andProfitLessThanOrEqualTo(BigDecimal value) {
            addCriterion("profit <=", value, "profit");
            return (Criteria) this;
        }

        public Criteria andProfitIn(List<BigDecimal> values) {
            addCriterion("profit in", values, "profit");
            return (Criteria) this;
        }

        public Criteria andProfitNotIn(List<BigDecimal> values) {
            addCriterion("profit not in", values, "profit");
            return (Criteria) this;
        }

        public Criteria andProfitBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("profit between", value1, value2, "profit");
            return (Criteria) this;
        }

        public Criteria andProfitNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("profit not between", value1, value2, "profit");
            return (Criteria) this;
        }

        public Criteria andTaxIsNull() {
            addCriterion("tax is null");
            return (Criteria) this;
        }

        public Criteria andTaxIsNotNull() {
            addCriterion("tax is not null");
            return (Criteria) this;
        }

        public Criteria andTaxEqualTo(BigDecimal value) {
            addCriterion("tax =", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxNotEqualTo(BigDecimal value) {
            addCriterion("tax <>", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxGreaterThan(BigDecimal value) {
            addCriterion("tax >", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("tax >=", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxLessThan(BigDecimal value) {
            addCriterion("tax <", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxLessThanOrEqualTo(BigDecimal value) {
            addCriterion("tax <=", value, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxIn(List<BigDecimal> values) {
            addCriterion("tax in", values, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxNotIn(List<BigDecimal> values) {
            addCriterion("tax not in", values, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("tax between", value1, value2, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("tax not between", value1, value2, "tax");
            return (Criteria) this;
        }

        public Criteria andTaxRateIsNull() {
            addCriterion("tax_rate is null");
            return (Criteria) this;
        }

        public Criteria andTaxRateIsNotNull() {
            addCriterion("tax_rate is not null");
            return (Criteria) this;
        }

        public Criteria andTaxRateEqualTo(BigDecimal value) {
            addCriterion("tax_rate =", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotEqualTo(BigDecimal value) {
            addCriterion("tax_rate <>", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateGreaterThan(BigDecimal value) {
            addCriterion("tax_rate >", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("tax_rate >=", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateLessThan(BigDecimal value) {
            addCriterion("tax_rate <", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("tax_rate <=", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateIn(List<BigDecimal> values) {
            addCriterion("tax_rate in", values, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotIn(List<BigDecimal> values) {
            addCriterion("tax_rate not in", values, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("tax_rate between", value1, value2, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("tax_rate not between", value1, value2, "taxRate");
            return (Criteria) this;
        }

        public Criteria andCommissionIsNull() {
            addCriterion("commission is null");
            return (Criteria) this;
        }

        public Criteria andCommissionIsNotNull() {
            addCriterion("commission is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionEqualTo(BigDecimal value) {
            addCriterion("commission =", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotEqualTo(BigDecimal value) {
            addCriterion("commission <>", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionGreaterThan(BigDecimal value) {
            addCriterion("commission >", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("commission >=", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionLessThan(BigDecimal value) {
            addCriterion("commission <", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionLessThanOrEqualTo(BigDecimal value) {
            addCriterion("commission <=", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionIn(List<BigDecimal> values) {
            addCriterion("commission in", values, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotIn(List<BigDecimal> values) {
            addCriterion("commission not in", values, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("commission between", value1, value2, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("commission not between", value1, value2, "commission");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeIsNull() {
            addCriterion("invoice_type is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeIsNotNull() {
            addCriterion("invoice_type is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeEqualTo(BigDecimal value) {
            addCriterion("invoice_type =", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeNotEqualTo(BigDecimal value) {
            addCriterion("invoice_type <>", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeGreaterThan(BigDecimal value) {
            addCriterion("invoice_type >", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("invoice_type >=", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeLessThan(BigDecimal value) {
            addCriterion("invoice_type <", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("invoice_type <=", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeIn(List<BigDecimal> values) {
            addCriterion("invoice_type in", values, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeNotIn(List<BigDecimal> values) {
            addCriterion("invoice_type not in", values, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("invoice_type between", value1, value2, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("invoice_type not between", value1, value2, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleIsNull() {
            addCriterion("invoice_title is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleIsNotNull() {
            addCriterion("invoice_title is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleEqualTo(String value) {
            addCriterion("invoice_title =", value, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleNotEqualTo(String value) {
            addCriterion("invoice_title <>", value, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleGreaterThan(String value) {
            addCriterion("invoice_title >", value, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleGreaterThanOrEqualTo(String value) {
            addCriterion("invoice_title >=", value, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleLessThan(String value) {
            addCriterion("invoice_title <", value, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleLessThanOrEqualTo(String value) {
            addCriterion("invoice_title <=", value, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleLike(String value) {
            addCriterion("invoice_title like", value, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleNotLike(String value) {
            addCriterion("invoice_title not like", value, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleIn(List<String> values) {
            addCriterion("invoice_title in", values, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleNotIn(List<String> values) {
            addCriterion("invoice_title not in", values, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleBetween(String value1, String value2) {
            addCriterion("invoice_title between", value1, value2, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceTitleNotBetween(String value1, String value2) {
            addCriterion("invoice_title not between", value1, value2, "invoiceTitle");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentIsNull() {
            addCriterion("invoice_content is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentIsNotNull() {
            addCriterion("invoice_content is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentEqualTo(String value) {
            addCriterion("invoice_content =", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentNotEqualTo(String value) {
            addCriterion("invoice_content <>", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentGreaterThan(String value) {
            addCriterion("invoice_content >", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentGreaterThanOrEqualTo(String value) {
            addCriterion("invoice_content >=", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentLessThan(String value) {
            addCriterion("invoice_content <", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentLessThanOrEqualTo(String value) {
            addCriterion("invoice_content <=", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentLike(String value) {
            addCriterion("invoice_content like", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentNotLike(String value) {
            addCriterion("invoice_content not like", value, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentIn(List<String> values) {
            addCriterion("invoice_content in", values, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentNotIn(List<String> values) {
            addCriterion("invoice_content not in", values, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentBetween(String value1, String value2) {
            addCriterion("invoice_content between", value1, value2, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andInvoiceContentNotBetween(String value1, String value2) {
            addCriterion("invoice_content not between", value1, value2, "invoiceContent");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdIsNull() {
            addCriterion("salesman_id is null");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdIsNotNull() {
            addCriterion("salesman_id is not null");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdEqualTo(Integer value) {
            addCriterion("salesman_id =", value, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdNotEqualTo(Integer value) {
            addCriterion("salesman_id <>", value, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdGreaterThan(Integer value) {
            addCriterion("salesman_id >", value, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("salesman_id >=", value, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdLessThan(Integer value) {
            addCriterion("salesman_id <", value, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdLessThanOrEqualTo(Integer value) {
            addCriterion("salesman_id <=", value, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdIn(List<Integer> values) {
            addCriterion("salesman_id in", values, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdNotIn(List<Integer> values) {
            addCriterion("salesman_id not in", values, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdBetween(Integer value1, Integer value2) {
            addCriterion("salesman_id between", value1, value2, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andSalesmanIdNotBetween(Integer value1, Integer value2) {
            addCriterion("salesman_id not between", value1, value2, "salesmanId");
            return (Criteria) this;
        }

        public Criteria andCheckerIdIsNull() {
            addCriterion("checker_id is null");
            return (Criteria) this;
        }

        public Criteria andCheckerIdIsNotNull() {
            addCriterion("checker_id is not null");
            return (Criteria) this;
        }

        public Criteria andCheckerIdEqualTo(Integer value) {
            addCriterion("checker_id =", value, "checkerId");
            return (Criteria) this;
        }

        public Criteria andCheckerIdNotEqualTo(Integer value) {
            addCriterion("checker_id <>", value, "checkerId");
            return (Criteria) this;
        }

        public Criteria andCheckerIdGreaterThan(Integer value) {
            addCriterion("checker_id >", value, "checkerId");
            return (Criteria) this;
        }

        public Criteria andCheckerIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("checker_id >=", value, "checkerId");
            return (Criteria) this;
        }

        public Criteria andCheckerIdLessThan(Integer value) {
            addCriterion("checker_id <", value, "checkerId");
            return (Criteria) this;
        }

        public Criteria andCheckerIdLessThanOrEqualTo(Integer value) {
            addCriterion("checker_id <=", value, "checkerId");
            return (Criteria) this;
        }

        public Criteria andCheckerIdIn(List<Integer> values) {
            addCriterion("checker_id in", values, "checkerId");
            return (Criteria) this;
        }

        public Criteria andCheckerIdNotIn(List<Integer> values) {
            addCriterion("checker_id not in", values, "checkerId");
            return (Criteria) this;
        }

        public Criteria andCheckerIdBetween(Integer value1, Integer value2) {
            addCriterion("checker_id between", value1, value2, "checkerId");
            return (Criteria) this;
        }

        public Criteria andCheckerIdNotBetween(Integer value1, Integer value2) {
            addCriterion("checker_id not between", value1, value2, "checkerId");
            return (Criteria) this;
        }

        public Criteria andFcheckerIdIsNull() {
            addCriterion("fchecker_id is null");
            return (Criteria) this;
        }

        public Criteria andFcheckerIdIsNotNull() {
            addCriterion("fchecker_id is not null");
            return (Criteria) this;
        }

        public Criteria andFcheckerIdEqualTo(Integer value) {
            addCriterion("fchecker_id =", value, "fcheckerId");
            return (Criteria) this;
        }

        public Criteria andFcheckerIdNotEqualTo(Integer value) {
            addCriterion("fchecker_id <>", value, "fcheckerId");
            return (Criteria) this;
        }

        public Criteria andFcheckerIdGreaterThan(Integer value) {
            addCriterion("fchecker_id >", value, "fcheckerId");
            return (Criteria) this;
        }

        public Criteria andFcheckerIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("fchecker_id >=", value, "fcheckerId");
            return (Criteria) this;
        }

        public Criteria andFcheckerIdLessThan(Integer value) {
            addCriterion("fchecker_id <", value, "fcheckerId");
            return (Criteria) this;
        }

        public Criteria andFcheckerIdLessThanOrEqualTo(Integer value) {
            addCriterion("fchecker_id <=", value, "fcheckerId");
            return (Criteria) this;
        }

        public Criteria andFcheckerIdIn(List<Integer> values) {
            addCriterion("fchecker_id in", values, "fcheckerId");
            return (Criteria) this;
        }

        public Criteria andFcheckerIdNotIn(List<Integer> values) {
            addCriterion("fchecker_id not in", values, "fcheckerId");
            return (Criteria) this;
        }

        public Criteria andFcheckerIdBetween(Integer value1, Integer value2) {
            addCriterion("fchecker_id between", value1, value2, "fcheckerId");
            return (Criteria) this;
        }

        public Criteria andFcheckerIdNotBetween(Integer value1, Integer value2) {
            addCriterion("fchecker_id not between", value1, value2, "fcheckerId");
            return (Criteria) this;
        }

        public Criteria andCheckouterIdIsNull() {
            addCriterion("checkouter_id is null");
            return (Criteria) this;
        }

        public Criteria andCheckouterIdIsNotNull() {
            addCriterion("checkouter_id is not null");
            return (Criteria) this;
        }

        public Criteria andCheckouterIdEqualTo(Integer value) {
            addCriterion("checkouter_id =", value, "checkouterId");
            return (Criteria) this;
        }

        public Criteria andCheckouterIdNotEqualTo(Integer value) {
            addCriterion("checkouter_id <>", value, "checkouterId");
            return (Criteria) this;
        }

        public Criteria andCheckouterIdGreaterThan(Integer value) {
            addCriterion("checkouter_id >", value, "checkouterId");
            return (Criteria) this;
        }

        public Criteria andCheckouterIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("checkouter_id >=", value, "checkouterId");
            return (Criteria) this;
        }

        public Criteria andCheckouterIdLessThan(Integer value) {
            addCriterion("checkouter_id <", value, "checkouterId");
            return (Criteria) this;
        }

        public Criteria andCheckouterIdLessThanOrEqualTo(Integer value) {
            addCriterion("checkouter_id <=", value, "checkouterId");
            return (Criteria) this;
        }

        public Criteria andCheckouterIdIn(List<Integer> values) {
            addCriterion("checkouter_id in", values, "checkouterId");
            return (Criteria) this;
        }

        public Criteria andCheckouterIdNotIn(List<Integer> values) {
            addCriterion("checkouter_id not in", values, "checkouterId");
            return (Criteria) this;
        }

        public Criteria andCheckouterIdBetween(Integer value1, Integer value2) {
            addCriterion("checkouter_id between", value1, value2, "checkouterId");
            return (Criteria) this;
        }

        public Criteria andCheckouterIdNotBetween(Integer value1, Integer value2) {
            addCriterion("checkouter_id not between", value1, value2, "checkouterId");
            return (Criteria) this;
        }

        public Criteria andStockoutNoIsNull() {
            addCriterion("stockout_no is null");
            return (Criteria) this;
        }

        public Criteria andStockoutNoIsNotNull() {
            addCriterion("stockout_no is not null");
            return (Criteria) this;
        }

        public Criteria andStockoutNoEqualTo(String value) {
            addCriterion("stockout_no =", value, "stockoutNo");
            return (Criteria) this;
        }

        public Criteria andStockoutNoNotEqualTo(String value) {
            addCriterion("stockout_no <>", value, "stockoutNo");
            return (Criteria) this;
        }

        public Criteria andStockoutNoGreaterThan(String value) {
            addCriterion("stockout_no >", value, "stockoutNo");
            return (Criteria) this;
        }

        public Criteria andStockoutNoGreaterThanOrEqualTo(String value) {
            addCriterion("stockout_no >=", value, "stockoutNo");
            return (Criteria) this;
        }

        public Criteria andStockoutNoLessThan(String value) {
            addCriterion("stockout_no <", value, "stockoutNo");
            return (Criteria) this;
        }

        public Criteria andStockoutNoLessThanOrEqualTo(String value) {
            addCriterion("stockout_no <=", value, "stockoutNo");
            return (Criteria) this;
        }

        public Criteria andStockoutNoLike(String value) {
            addCriterion("stockout_no like", value, "stockoutNo");
            return (Criteria) this;
        }

        public Criteria andStockoutNoNotLike(String value) {
            addCriterion("stockout_no not like", value, "stockoutNo");
            return (Criteria) this;
        }

        public Criteria andStockoutNoIn(List<String> values) {
            addCriterion("stockout_no in", values, "stockoutNo");
            return (Criteria) this;
        }

        public Criteria andStockoutNoNotIn(List<String> values) {
            addCriterion("stockout_no not in", values, "stockoutNo");
            return (Criteria) this;
        }

        public Criteria andStockoutNoBetween(String value1, String value2) {
            addCriterion("stockout_no between", value1, value2, "stockoutNo");
            return (Criteria) this;
        }

        public Criteria andStockoutNoNotBetween(String value1, String value2) {
            addCriterion("stockout_no not between", value1, value2, "stockoutNo");
            return (Criteria) this;
        }

        public Criteria andFlagNameIsNull() {
            addCriterion("flag_name is null");
            return (Criteria) this;
        }

        public Criteria andFlagNameIsNotNull() {
            addCriterion("flag_name is not null");
            return (Criteria) this;
        }

        public Criteria andFlagNameEqualTo(String value) {
            addCriterion("flag_name =", value, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameNotEqualTo(String value) {
            addCriterion("flag_name <>", value, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameGreaterThan(String value) {
            addCriterion("flag_name >", value, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameGreaterThanOrEqualTo(String value) {
            addCriterion("flag_name >=", value, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameLessThan(String value) {
            addCriterion("flag_name <", value, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameLessThanOrEqualTo(String value) {
            addCriterion("flag_name <=", value, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameLike(String value) {
            addCriterion("flag_name like", value, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameNotLike(String value) {
            addCriterion("flag_name not like", value, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameIn(List<String> values) {
            addCriterion("flag_name in", values, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameNotIn(List<String> values) {
            addCriterion("flag_name not in", values, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameBetween(String value1, String value2) {
            addCriterion("flag_name between", value1, value2, "flagName");
            return (Criteria) this;
        }

        public Criteria andFlagNameNotBetween(String value1, String value2) {
            addCriterion("flag_name not between", value1, value2, "flagName");
            return (Criteria) this;
        }

        public Criteria andTradeFromIsNull() {
            addCriterion("trade_from is null");
            return (Criteria) this;
        }

        public Criteria andTradeFromIsNotNull() {
            addCriterion("trade_from is not null");
            return (Criteria) this;
        }

        public Criteria andTradeFromEqualTo(Integer value) {
            addCriterion("trade_from =", value, "tradeFrom");
            return (Criteria) this;
        }

        public Criteria andTradeFromNotEqualTo(Integer value) {
            addCriterion("trade_from <>", value, "tradeFrom");
            return (Criteria) this;
        }

        public Criteria andTradeFromGreaterThan(Integer value) {
            addCriterion("trade_from >", value, "tradeFrom");
            return (Criteria) this;
        }

        public Criteria andTradeFromGreaterThanOrEqualTo(Integer value) {
            addCriterion("trade_from >=", value, "tradeFrom");
            return (Criteria) this;
        }

        public Criteria andTradeFromLessThan(Integer value) {
            addCriterion("trade_from <", value, "tradeFrom");
            return (Criteria) this;
        }

        public Criteria andTradeFromLessThanOrEqualTo(Integer value) {
            addCriterion("trade_from <=", value, "tradeFrom");
            return (Criteria) this;
        }

        public Criteria andTradeFromIn(List<Integer> values) {
            addCriterion("trade_from in", values, "tradeFrom");
            return (Criteria) this;
        }

        public Criteria andTradeFromNotIn(List<Integer> values) {
            addCriterion("trade_from not in", values, "tradeFrom");
            return (Criteria) this;
        }

        public Criteria andTradeFromBetween(Integer value1, Integer value2) {
            addCriterion("trade_from between", value1, value2, "tradeFrom");
            return (Criteria) this;
        }

        public Criteria andTradeFromNotBetween(Integer value1, Integer value2) {
            addCriterion("trade_from not between", value1, value2, "tradeFrom");
            return (Criteria) this;
        }

        public Criteria andSingleSpecNoIsNull() {
            addCriterion("single_spec_no is null");
            return (Criteria) this;
        }

        public Criteria andSingleSpecNoIsNotNull() {
            addCriterion("single_spec_no is not null");
            return (Criteria) this;
        }

        public Criteria andSingleSpecNoEqualTo(String value) {
            addCriterion("single_spec_no =", value, "singleSpecNo");
            return (Criteria) this;
        }

        public Criteria andSingleSpecNoNotEqualTo(String value) {
            addCriterion("single_spec_no <>", value, "singleSpecNo");
            return (Criteria) this;
        }

        public Criteria andSingleSpecNoGreaterThan(String value) {
            addCriterion("single_spec_no >", value, "singleSpecNo");
            return (Criteria) this;
        }

        public Criteria andSingleSpecNoGreaterThanOrEqualTo(String value) {
            addCriterion("single_spec_no >=", value, "singleSpecNo");
            return (Criteria) this;
        }

        public Criteria andSingleSpecNoLessThan(String value) {
            addCriterion("single_spec_no <", value, "singleSpecNo");
            return (Criteria) this;
        }

        public Criteria andSingleSpecNoLessThanOrEqualTo(String value) {
            addCriterion("single_spec_no <=", value, "singleSpecNo");
            return (Criteria) this;
        }

        public Criteria andSingleSpecNoLike(String value) {
            addCriterion("single_spec_no like", value, "singleSpecNo");
            return (Criteria) this;
        }

        public Criteria andSingleSpecNoNotLike(String value) {
            addCriterion("single_spec_no not like", value, "singleSpecNo");
            return (Criteria) this;
        }

        public Criteria andSingleSpecNoIn(List<String> values) {
            addCriterion("single_spec_no in", values, "singleSpecNo");
            return (Criteria) this;
        }

        public Criteria andSingleSpecNoNotIn(List<String> values) {
            addCriterion("single_spec_no not in", values, "singleSpecNo");
            return (Criteria) this;
        }

        public Criteria andSingleSpecNoBetween(String value1, String value2) {
            addCriterion("single_spec_no between", value1, value2, "singleSpecNo");
            return (Criteria) this;
        }

        public Criteria andSingleSpecNoNotBetween(String value1, String value2) {
            addCriterion("single_spec_no not between", value1, value2, "singleSpecNo");
            return (Criteria) this;
        }

        public Criteria andRawGoodsCountIsNull() {
            addCriterion("raw_goods_count is null");
            return (Criteria) this;
        }

        public Criteria andRawGoodsCountIsNotNull() {
            addCriterion("raw_goods_count is not null");
            return (Criteria) this;
        }

        public Criteria andRawGoodsCountEqualTo(BigDecimal value) {
            addCriterion("raw_goods_count =", value, "rawGoodsCount");
            return (Criteria) this;
        }

        public Criteria andRawGoodsCountNotEqualTo(BigDecimal value) {
            addCriterion("raw_goods_count <>", value, "rawGoodsCount");
            return (Criteria) this;
        }

        public Criteria andRawGoodsCountGreaterThan(BigDecimal value) {
            addCriterion("raw_goods_count >", value, "rawGoodsCount");
            return (Criteria) this;
        }

        public Criteria andRawGoodsCountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("raw_goods_count >=", value, "rawGoodsCount");
            return (Criteria) this;
        }

        public Criteria andRawGoodsCountLessThan(BigDecimal value) {
            addCriterion("raw_goods_count <", value, "rawGoodsCount");
            return (Criteria) this;
        }

        public Criteria andRawGoodsCountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("raw_goods_count <=", value, "rawGoodsCount");
            return (Criteria) this;
        }

        public Criteria andRawGoodsCountIn(List<BigDecimal> values) {
            addCriterion("raw_goods_count in", values, "rawGoodsCount");
            return (Criteria) this;
        }

        public Criteria andRawGoodsCountNotIn(List<BigDecimal> values) {
            addCriterion("raw_goods_count not in", values, "rawGoodsCount");
            return (Criteria) this;
        }

        public Criteria andRawGoodsCountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("raw_goods_count between", value1, value2, "rawGoodsCount");
            return (Criteria) this;
        }

        public Criteria andRawGoodsCountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("raw_goods_count not between", value1, value2, "rawGoodsCount");
            return (Criteria) this;
        }

        public Criteria andRawGoodsTypeCountIsNull() {
            addCriterion("raw_goods_type_count is null");
            return (Criteria) this;
        }

        public Criteria andRawGoodsTypeCountIsNotNull() {
            addCriterion("raw_goods_type_count is not null");
            return (Criteria) this;
        }

        public Criteria andRawGoodsTypeCountEqualTo(Integer value) {
            addCriterion("raw_goods_type_count =", value, "rawGoodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andRawGoodsTypeCountNotEqualTo(Integer value) {
            addCriterion("raw_goods_type_count <>", value, "rawGoodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andRawGoodsTypeCountGreaterThan(Integer value) {
            addCriterion("raw_goods_type_count >", value, "rawGoodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andRawGoodsTypeCountGreaterThanOrEqualTo(Integer value) {
            addCriterion("raw_goods_type_count >=", value, "rawGoodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andRawGoodsTypeCountLessThan(Integer value) {
            addCriterion("raw_goods_type_count <", value, "rawGoodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andRawGoodsTypeCountLessThanOrEqualTo(Integer value) {
            addCriterion("raw_goods_type_count <=", value, "rawGoodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andRawGoodsTypeCountIn(List<Integer> values) {
            addCriterion("raw_goods_type_count in", values, "rawGoodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andRawGoodsTypeCountNotIn(List<Integer> values) {
            addCriterion("raw_goods_type_count not in", values, "rawGoodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andRawGoodsTypeCountBetween(Integer value1, Integer value2) {
            addCriterion("raw_goods_type_count between", value1, value2, "rawGoodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andRawGoodsTypeCountNotBetween(Integer value1, Integer value2) {
            addCriterion("raw_goods_type_count not between", value1, value2, "rawGoodsTypeCount");
            return (Criteria) this;
        }

        public Criteria andCurrencyIsNull() {
            addCriterion("currency is null");
            return (Criteria) this;
        }

        public Criteria andCurrencyIsNotNull() {
            addCriterion("currency is not null");
            return (Criteria) this;
        }

        public Criteria andCurrencyEqualTo(String value) {
            addCriterion("currency =", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotEqualTo(String value) {
            addCriterion("currency <>", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyGreaterThan(String value) {
            addCriterion("currency >", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyGreaterThanOrEqualTo(String value) {
            addCriterion("currency >=", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLessThan(String value) {
            addCriterion("currency <", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLessThanOrEqualTo(String value) {
            addCriterion("currency <=", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLike(String value) {
            addCriterion("currency like", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotLike(String value) {
            addCriterion("currency not like", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyIn(List<String> values) {
            addCriterion("currency in", values, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotIn(List<String> values) {
            addCriterion("currency not in", values, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyBetween(String value1, String value2) {
            addCriterion("currency between", value1, value2, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotBetween(String value1, String value2) {
            addCriterion("currency not between", value1, value2, "currency");
            return (Criteria) this;
        }

        public Criteria andSplitPackageNumIsNull() {
            addCriterion("split_package_num is null");
            return (Criteria) this;
        }

        public Criteria andSplitPackageNumIsNotNull() {
            addCriterion("split_package_num is not null");
            return (Criteria) this;
        }

        public Criteria andSplitPackageNumEqualTo(Integer value) {
            addCriterion("split_package_num =", value, "splitPackageNum");
            return (Criteria) this;
        }

        public Criteria andSplitPackageNumNotEqualTo(Integer value) {
            addCriterion("split_package_num <>", value, "splitPackageNum");
            return (Criteria) this;
        }

        public Criteria andSplitPackageNumGreaterThan(Integer value) {
            addCriterion("split_package_num >", value, "splitPackageNum");
            return (Criteria) this;
        }

        public Criteria andSplitPackageNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("split_package_num >=", value, "splitPackageNum");
            return (Criteria) this;
        }

        public Criteria andSplitPackageNumLessThan(Integer value) {
            addCriterion("split_package_num <", value, "splitPackageNum");
            return (Criteria) this;
        }

        public Criteria andSplitPackageNumLessThanOrEqualTo(Integer value) {
            addCriterion("split_package_num <=", value, "splitPackageNum");
            return (Criteria) this;
        }

        public Criteria andSplitPackageNumIn(List<Integer> values) {
            addCriterion("split_package_num in", values, "splitPackageNum");
            return (Criteria) this;
        }

        public Criteria andSplitPackageNumNotIn(List<Integer> values) {
            addCriterion("split_package_num not in", values, "splitPackageNum");
            return (Criteria) this;
        }

        public Criteria andSplitPackageNumBetween(Integer value1, Integer value2) {
            addCriterion("split_package_num between", value1, value2, "splitPackageNum");
            return (Criteria) this;
        }

        public Criteria andSplitPackageNumNotBetween(Integer value1, Integer value2) {
            addCriterion("split_package_num not between", value1, value2, "splitPackageNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdIsNull() {
            addCriterion("invoice_id is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdIsNotNull() {
            addCriterion("invoice_id is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdEqualTo(Integer value) {
            addCriterion("invoice_id =", value, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdNotEqualTo(Integer value) {
            addCriterion("invoice_id <>", value, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdGreaterThan(Integer value) {
            addCriterion("invoice_id >", value, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("invoice_id >=", value, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdLessThan(Integer value) {
            addCriterion("invoice_id <", value, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdLessThanOrEqualTo(Integer value) {
            addCriterion("invoice_id <=", value, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdIn(List<Integer> values) {
            addCriterion("invoice_id in", values, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdNotIn(List<Integer> values) {
            addCriterion("invoice_id not in", values, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdBetween(Integer value1, Integer value2) {
            addCriterion("invoice_id between", value1, value2, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andInvoiceIdNotBetween(Integer value1, Integer value2) {
            addCriterion("invoice_id not between", value1, value2, "invoiceId");
            return (Criteria) this;
        }

        public Criteria andVersionIdIsNull() {
            addCriterion("version_id is null");
            return (Criteria) this;
        }

        public Criteria andVersionIdIsNotNull() {
            addCriterion("version_id is not null");
            return (Criteria) this;
        }

        public Criteria andVersionIdEqualTo(Integer value) {
            addCriterion("version_id =", value, "versionId");
            return (Criteria) this;
        }

        public Criteria andVersionIdNotEqualTo(Integer value) {
            addCriterion("version_id <>", value, "versionId");
            return (Criteria) this;
        }

        public Criteria andVersionIdGreaterThan(Integer value) {
            addCriterion("version_id >", value, "versionId");
            return (Criteria) this;
        }

        public Criteria andVersionIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("version_id >=", value, "versionId");
            return (Criteria) this;
        }

        public Criteria andVersionIdLessThan(Integer value) {
            addCriterion("version_id <", value, "versionId");
            return (Criteria) this;
        }

        public Criteria andVersionIdLessThanOrEqualTo(Integer value) {
            addCriterion("version_id <=", value, "versionId");
            return (Criteria) this;
        }

        public Criteria andVersionIdIn(List<Integer> values) {
            addCriterion("version_id in", values, "versionId");
            return (Criteria) this;
        }

        public Criteria andVersionIdNotIn(List<Integer> values) {
            addCriterion("version_id not in", values, "versionId");
            return (Criteria) this;
        }

        public Criteria andVersionIdBetween(Integer value1, Integer value2) {
            addCriterion("version_id between", value1, value2, "versionId");
            return (Criteria) this;
        }

        public Criteria andVersionIdNotBetween(Integer value1, Integer value2) {
            addCriterion("version_id not between", value1, value2, "versionId");
            return (Criteria) this;
        }

        public Criteria andModifiedIsNull() {
            addCriterion("modified is null");
            return (Criteria) this;
        }

        public Criteria andModifiedIsNotNull() {
            addCriterion("modified is not null");
            return (Criteria) this;
        }

        public Criteria andModifiedEqualTo(Date value) {
            addCriterion("modified =", value, "modified");
            return (Criteria) this;
        }

        public Criteria andModifiedNotEqualTo(Date value) {
            addCriterion("modified <>", value, "modified");
            return (Criteria) this;
        }

        public Criteria andModifiedGreaterThan(Date value) {
            addCriterion("modified >", value, "modified");
            return (Criteria) this;
        }

        public Criteria andModifiedGreaterThanOrEqualTo(Date value) {
            addCriterion("modified >=", value, "modified");
            return (Criteria) this;
        }

        public Criteria andModifiedLessThan(Date value) {
            addCriterion("modified <", value, "modified");
            return (Criteria) this;
        }

        public Criteria andModifiedLessThanOrEqualTo(Date value) {
            addCriterion("modified <=", value, "modified");
            return (Criteria) this;
        }

        public Criteria andModifiedIn(List<Date> values) {
            addCriterion("modified in", values, "modified");
            return (Criteria) this;
        }

        public Criteria andModifiedNotIn(List<Date> values) {
            addCriterion("modified not in", values, "modified");
            return (Criteria) this;
        }

        public Criteria andModifiedBetween(Date value1, Date value2) {
            addCriterion("modified between", value1, value2, "modified");
            return (Criteria) this;
        }

        public Criteria andModifiedNotBetween(Date value1, Date value2) {
            addCriterion("modified not between", value1, value2, "modified");
            return (Criteria) this;
        }

        public Criteria andCreatedIsNull() {
            addCriterion("created is null");
            return (Criteria) this;
        }

        public Criteria andCreatedIsNotNull() {
            addCriterion("created is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedEqualTo(Date value) {
            addCriterion("created =", value, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedNotEqualTo(Date value) {
            addCriterion("created <>", value, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedGreaterThan(Date value) {
            addCriterion("created >", value, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedGreaterThanOrEqualTo(Date value) {
            addCriterion("created >=", value, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedLessThan(Date value) {
            addCriterion("created <", value, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedLessThanOrEqualTo(Date value) {
            addCriterion("created <=", value, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedIn(List<Date> values) {
            addCriterion("created in", values, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedNotIn(List<Date> values) {
            addCriterion("created not in", values, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedBetween(Date value1, Date value2) {
            addCriterion("created between", value1, value2, "created");
            return (Criteria) this;
        }

        public Criteria andCreatedNotBetween(Date value1, Date value2) {
            addCriterion("created not between", value1, value2, "created");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeIsNull() {
            addCriterion("id_card_type is null");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeIsNotNull() {
            addCriterion("id_card_type is not null");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeEqualTo(Integer value) {
            addCriterion("id_card_type =", value, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeNotEqualTo(Integer value) {
            addCriterion("id_card_type <>", value, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeGreaterThan(Integer value) {
            addCriterion("id_card_type >", value, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("id_card_type >=", value, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeLessThan(Integer value) {
            addCriterion("id_card_type <", value, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeLessThanOrEqualTo(Integer value) {
            addCriterion("id_card_type <=", value, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeIn(List<Integer> values) {
            addCriterion("id_card_type in", values, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeNotIn(List<Integer> values) {
            addCriterion("id_card_type not in", values, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeBetween(Integer value1, Integer value2) {
            addCriterion("id_card_type between", value1, value2, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("id_card_type not between", value1, value2, "idCardType");
            return (Criteria) this;
        }

        public Criteria andIdCardIsNull() {
            addCriterion("id_card is null");
            return (Criteria) this;
        }

        public Criteria andIdCardIsNotNull() {
            addCriterion("id_card is not null");
            return (Criteria) this;
        }

        public Criteria andIdCardEqualTo(String value) {
            addCriterion("id_card =", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardNotEqualTo(String value) {
            addCriterion("id_card <>", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardGreaterThan(String value) {
            addCriterion("id_card >", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardGreaterThanOrEqualTo(String value) {
            addCriterion("id_card >=", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardLessThan(String value) {
            addCriterion("id_card <", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardLessThanOrEqualTo(String value) {
            addCriterion("id_card <=", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardLike(String value) {
            addCriterion("id_card like", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardNotLike(String value) {
            addCriterion("id_card not like", value, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardIn(List<String> values) {
            addCriterion("id_card in", values, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardNotIn(List<String> values) {
            addCriterion("id_card not in", values, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardBetween(String value1, String value2) {
            addCriterion("id_card between", value1, value2, "idCard");
            return (Criteria) this;
        }

        public Criteria andIdCardNotBetween(String value1, String value2) {
            addCriterion("id_card not between", value1, value2, "idCard");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}